SSMS Tips & Tricks – Scripting Multiple Objects
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,349 reads
Blog Posts
T-SQL LOWER(): Change an all uppercase string to lower case
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
885 reads
A 22 Hour Layover
I joked about having a 22 hour layover in Denver yesterday and a few people were wondering what airline screwed...
2011-04-01
846 reads
Announcing The Association For SQL Server
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
393 reads
April Question: Which high availability option(s) do you employ for SQL Server instances, and why did you choose them?
As DBAs, we are responsible for the protection of our organization’s data, and we have many different options to protect...
2011-04-01
595 reads
Changing Directions
I See Dead Tech….
Knowing when a technology is dying is always a good skill to have. Like most of my...
2011-04-01
915 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In...
2011-04-01
656 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In SQL Server an index helps to improve query performance...
2011-04-01
5 reads
Powershell Day 1
Day 1 Introduction to Powershell I got inspired by great people like Paul Randal and Glenn Berry and decided to...
2011-04-01
819 reads
Reflections on Dev Connections / SQL Connections
When SQL Connections in the spring was announced, the folks at Red Gate and SQL Server Central reached out to...
2011-04-01
842 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers