Contained Databases – Preventing Collation Conflicts
One of the demos from my Contained Databases talk looks at the issues you can have when your database collation...
2012-06-14 (first published: 2012-06-07)
2,328 reads
Blog Posts
Latest Presentation on SQL Server Mirroring Given at Transcontinental's Offices
With a handful of System Administrators, Network Specialists and DBAs, I gave my third presentation on SQL Server Mirroring this...
2012-06-14
1,512 reads
NomCom, what it’s all about
I submitted my application for the NomCom last week and the polls opened up yesterday. I’ve seen an amazing amount...
2012-06-14
615 reads
PASS Data Architecture VC presents Neil Hambly–Improve Data Quality & Integrity using Constraint
Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...
2012-06-14
696 reads
Running for the #SQLPass #NomCom
Guess, what? I’ve thrown my hat in to the elections for the Nomination Committee for PASS. That means that I...
2012-06-14
831 reads
@LearningTree: 2108 SQL Server 2012 Database Administration
This past week my international adventures have continued. As some of you know, for the past couple of years, I...
2012-06-13
1,536 reads
Command Line Prompts for Checking Active Directory Membership
Using Active Directory groups are a great way to manage and maintain security for a solution. Think about if you...
2012-06-13
1,894 reads
Database Tables
Today I was asked for "a list of all tables in all databases" on a particular instance of SQL Server. ...
2012-06-13
875 reads
Guest Post – The Last Starfighter
Today I am delighted to be able to share with you a guest post from one of my all time...
2012-06-13
1,203 reads
PASS 2012 NomCom
I’m officially on the slate and running for the PASS 2012 Nomination Committee!
I love the SQL Community and everything it embodies. ...
2012-06-13
657 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers