NOLOCK – truth
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that...
2010-11-30
1,509 reads
Multiple Mirrors
Up through SQL Server 2008 R2 database mirroring has been limited to a single mirror for each database. While that...
2010-11-30
5,481 reads
SSIS Package Annotation in Denali
If you are anything like me, you document your SSIS packages for those who may have to maintain them after...
2010-11-30
3,771 reads
Certificate Based Application Roles
What if I told you that you could sign an assembly that your Windows application uses with a certificate, load...
2010-11-30
1,595 reads
Executing PowerShell in SQL Server Redux
A while ago I blogged about using xp_cmdshell to execute a PowerShell script in SQL Server and return a result...
2010-11-30
1,635 reads
Drumroll Please…
Defensive Db Programming Chapter 10 After dragging this review on for months now, it is finally time to bring this bad boy home and wrap it up. I have...
2010-11-29
9 reads
Drumroll Please…
Defensive Db Programming Chapter 10
After dragging this review on for months now, it is finally time to bring this bad...
2010-11-29
1,385 reads
PASS Update #48
It’s the end of November and this will probably be my last update on PASS for the year as things...
2010-11-29
1,565 reads
TechEd 2011
TechEd will be in Atlanta next year, May 16-19, 2011 at the Georgia World Conference Center. I went this year...
2010-11-29
1,536 reads
Android Adventures–Part 2
I’ve been living with my Droid X phone for a couple weeks now. It’s definitely a big change from my...
2010-11-29
1,486 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers