Powershell: Calculating Seven Day Retention for Security Event Logs
I needed to figure out how much space was required to maintain 7 days of event log entries for the...
2010-11-17
2,350 reads
Handling Type II Dimension with the MERGE Statement
Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS. However, as we all know...
2010-11-17
2,011 reads
Dynamically Backing Up All User Databases in SQL Server
I recently had a request from a client to come up with a routine to do a full compressed database...
2010-11-16
1,419 reads
SQL Server Team-Based Development
The new book is available in a free download from Red Gate. I had a lot of fun working on...
2010-11-16
1,169 reads
PASS Summit Report 2: Seattle Again?
There is always a lot of talk about the fact that we have been in Seattle several years in a...
2010-11-16
1,155 reads
The SQL Server MCM Training Has Changed
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft...
2010-11-16
2,441 reads
SQL Server 2008 Service Pack 2 Cumulative Update 1
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 1, which is Build 4266. I count 67 fixes...
2010-11-16
1,008 reads
The World’s Largest
Each year, the Georgia Bulldogs and the Florida Gators meet on the college grid iron in what’s called the world’s...
2010-11-16
533 reads
PASSMN Meeting Today
Check us out today by either traveling down to Bloomington or jumping in and joining us online. Today Minnesota’s SQL...
2010-11-16
765 reads
PASS Update #47–Election Review Committee
As always, this represents my own views, I’m speaking only for me and not the entire PASS Board.
Early last week...
2010-11-16
678 reads
Blogs
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...
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
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