Select * from dbo.FAIL: invalid metadata in views and user defined functions
This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I...
2010-12-16
1,137 reads
1.5 Years in, U.K. Information Commissioner Christopher Graham, Delivers on the Data Protection Act
A year after the Telegraph reported that Information Commissioner Graham would pledge a fierce approach to the stonewalling approach of...
2010-12-16
1,491 reads
Giving Thanks
I often say I am where I am in the community because of other folks. As we approach the close...
2010-12-16
728 reads
SQL Server Storage Internals Part 2 - Partitions and Allocation Units
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
2010-12-16
15,179 reads
Insert_Identity Permissions
Despite my joking with Aaron Bertrand on Twitter that his suggestion on Connect got voted down because he’s Canadian, I...
2010-12-16
1,040 reads
Number of sessions per database
Sometimes when we need to do some maintenance on a SQL server, you need to verify which users are connected...
2010-12-16
1,441 reads
SQLRally Session Submissions
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of...
2010-12-16
542 reads
Pragmatically Thankful
This season, as we continue to grow and partner with some of the best of the best in the industry....
2010-12-15
512 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not end with the birth of our baby girl two...
2010-12-15
12 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not...
2010-12-15
544 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
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
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...
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