SQL Validation Functions - 4 Cool UDF's to have handy

Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...

Should a DBA be involved in the physical set up of a Database server? Part1

There is always some disconnect between the network admins and the DBA’s regarding hardware set up of a SQL Server....

Powershell Day 5

Day 5 Programming in Powershell Part 3 Now as you know all information, in this blog we will look for...

SQL Server Role Membership

How well do you know the security in your SQL instances?  Do you know who has sysadmin level permissions?  SQL Server provides a few methods for you to find...

SQL Server Role Membership

How well do you know the security in your SQL instances?  Do you know who has sysadmin level permissions?  SQL...

Epsilon Data Breach and Staying Safe

By now, you may have received an email from one of the larger businesses you've given your email address to...

T-SQL UPPER(): Change an all lowercase string to uppercase

The T-SQL UPPER() command allows you to change a lowercase string to an uppercase string.
For example, it will allow you to change the word...

SqlSaturday #71–Boston Recap: An Upscale Saturday

I had the pleasure of attending and presenting at SQLSaturday #71 – Boston on April 2nd.  Adam Machanic (Blog|Twitter), Mike Walsh (Blog|Twitter), Tom LaRock (Blog|Twitter), Grant Fritchey (Blog|Twitter) and...

Meme Monday: 11 Words or Less

Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:

Community is nice, but displaces work if...

Meme Monday

Replication: It's Not Really As Bad As SQLRockStar Says It Is
(Wondering what the heck this is supposed to be about?...