Search this blog
Steve’s tweets
- Join me next Tuesday at 10am EST for a webinar on what we learned at the PASS Summit attendee.gotowebinar.com/register/42255… 1 day ago
- @dbahiker @Kendra_Little @ShawnJohnsonDBA Glad you got it back. 1 day ago
- RT @mmarie: @JamesMcG_MSBI @SQLSocialite @FerrariAlberto Yes! I may have ranted about presentation templates and extra small fonts previous… 1 day 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
- ETL
- Friday Poll
- GDPR
- hardware
- high availability
- Humor
- life
- Linux
- 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
Fun with Savepoints–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I haven’t spent a lot of time with savepoints, but I did find a question recently and thought I’d … Continue reading
Break Problems Down
Recently I was pouring over a few questions in the forums and noticed something that I would think is obvious, but apparently it isn’t so for other people. A poster was attempting to run a query across multiple databases and … Continue reading
Republish: Embrace Stored Procedures
I’m getting home today,but not sure how wiped out I’ll be. So, one last republish: Embrace Stored Procedures
Finding Objects in a Schema #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 things I needed to do recently was move some objects from one schema to another. I … Continue reading
No More Mysterious Truncation
If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions a trace flag, which some of you might appreciate. Here’s a little repro: As you can see, the plee … Continue reading
Moving Objects to a New Schema
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I haven’t had the need to move an object from one schema to another in years. Really since SQL … Continue reading
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
