JTDS & Grails
Recently I had the chance to do some tuning on a system that was built using Grails (formerly Groovy on...
2011-02-28
2,480 reads
SQLskills SQL Server Immersion Training: A Retrospective
Last week I attended the inaugural training event of the new four-week SQL Server Immersion Training offered by Kimberly Tripp...
2011-02-28
2,009 reads
Adventure Works Sample Database Diagrams
Most of my examples utilize either adhoc type of data samples or one of the versions of AdventureWorks. I do...
2011-02-27
2,921 reads
Quests Performance Monitor Counters Poster
I just wanted to take a moment to thank Kevin Kline, Brent Ozar, Christian Bolton, Bob Ward, Rod Colledge and...
2011-02-27
3,041 reads
SQLskills Immersion Event on Internals and Performance – Day 5
Overview
Today was the fifth and final day of the Internals & Performance immersion event. I have really enjoyed learning from not...
2011-02-26
1,783 reads
Test Complete – MCM
I took the MCM test today, and finished it. I needed the time allotted and it was, well, an experience....
2011-02-25
1,789 reads
Finding Compressed Tables
Have you been working with compression? Have you inherited a database that may or may not have some tables compressed? On occasion you may want to know what the...
2011-02-25
20 reads
Finding Compressed Tables
Have you been working with compression? Have you inherited a database that may or may not have some tables compressed?...
2011-02-25
1,988 reads
PASS Update #53 (Bylaws)
This week we posted some pending changes to the PASS bylaws. We try to do a review at least once...
2011-02-25
1,568 reads
Changes to the SSIS Slowly Changing Dimension Component
Probably not the kind of change you're expecting. I've recently been contacted by the Kimball Group, and they've asked me...
2011-02-25
3,268 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