A pattern to match correctly on a value or a NULL
As you may have noticed if you read my blog I learn a lot from trolling various forums. In this...
2015-08-05
1,283 reads
As you may have noticed if you read my blog I learn a lot from trolling various forums. In this...
2015-08-05
1,283 reads
I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF...
2015-08-03
942 reads
I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of...
2015-07-29
1,258 reads
I’ve been doing a lot of research recently for my permissions session and for a project at work. During said...
2015-07-27
1,199 reads
A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had...
2015-07-24 (first published: 2015-07-20)
2,173 reads
Last year Kirsten Benzel(b/t) and Argenis Fernandez(b/t) did this amazing thing. They organized a campaign and raised over $13,000 for...
2015-07-22
685 reads
It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just...
2015-07-21 (first published: 2015-07-14)
1,431 reads
Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10...
2015-07-16
988 reads
I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse....
2015-07-13 (first published: 2015-07-06)
2,630 reads
What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in...
2015-07-08
659 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers