Search this blog
Steve’s tweets
- @SQLDiplomat @ScottWlaschin Thanks. It is an interesting way to look at your system and how to safely change it 2 hours ago
- Next week is #SQLSatPitt. I'll be there, my first time in the city. If you're nearby, register for the #sqlsat on S… twitter.com/i/web/status/1… 5 hours ago
- What is Projectsv13 in SQL Change Automation? voiceofthedba.com/2018/09/19/wha… https://t.co/0UiWNzjybl 6 hours ago
Friends of Redgate
MVP Award
Tags
- administration
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- bloopers
- business
- Business Intelligence
- career
- career
- cell phone
- Cloud Computing
- computers
- continuous delivery
- continuous integration
- data
- data analysis
- database design
- databases
- Database Weekly
- dbatools
- deployment
- Dev Connections
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- patching
- Performance
- powershell
- presentations
- Redgate
- sabbatical
- security
- software development
- software development
- speaking
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServer
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- training
- travel
- tsqlt
- vacation
- version control
- virtualization
- windows
- work
Tag Archives: T-SQL
Republish: I Feel Like a Magician
I’m off in the UK and buried with other work, so a republish today. I Feel Like a Magician
T-SQL Tuesday #106 – Trigger Headaches or Happiness
Since I took over the T-SQL Tuesday a few months ago, I decided I ought to host again. Especially since I’ve done it twice, but Wayne Sheffield got his third spot last month. Gotta keep up with Mr. Sheffield. Triggers, … Continue reading
Generating a Constrained Random Date–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There have been lots of posts on the topic of generating random values, and some great articles. One of … Continue reading
Remember the Default Window
I ran across a question recently from a user about why they had strange results from a windowing query. This is better explained with an example, so let’s look at one. I have some data in a table. This is … Continue reading
Will Terminators Be Required?
I was looking at an article the other day and noticed that there was a CTE sample with the semicolon on the line before the code. I’ve been seeing this convention for years, starting your CTE with a semicolon because … Continue reading
Solving Ken’s FizzBuzz 3D–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I like the FizzBuzz test. It’s cute and fun, and I’ve had my kids solve it, just to think … Continue reading
Finding Inconsistent Key Values–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was reading Iris Classon’s blog recently and ran across a post on her day at work. I think … Continue reading
Getting All Users
I saw someone that wanted to get all users from all databases on their instance. Seems like that ought to be simple, right? The user wanted to use sp_MSforeachdb to query users, but wanted a single result set for all … Continue reading
Defining FKs in CREATE TABLE–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the important things that a database developer can do is to define Foreign Keys (FK) at table … Continue reading
Exploring the Caves of Code Analysis in #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about a few of the items, and this post continues on with a feature … Continue reading
