Upcoming SQL Saturday Sessions
September is a wild month for me! This Saturday, September 14th, I will be at Kansas City’s next SQL Saturday #191...
2013-09-12
739 reads
Blog Posts
Certifications: What are they good for?
Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion about the program and...
2013-09-11
547 reads
Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle Poolet summarizes it beautifully – “consider the data warehouse...
2013-09-11
24 reads
Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle...
2013-09-11
731 reads
Data Warehousing Tip: Using T-SQL vs SSIS for Slowly Changing Dimension (SCD) Types 1 and 2
Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform ,however, it does not process large dimensional datasets...
2013-09-11
37 reads
Data Warehousing Tip: Using T-SQL vs SSIS for Slowly Changing Dimension (SCD) Types 1 and 2
Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform...
2013-09-11
1,127 reads
Database DoS Whitepaper from Securosis
Securosis has released a whitepaper on their research with regards to database denial-of-service attacks. This whitepaper is platform agnostic. It...
2013-09-11
2,037 reads
Execution Plan Cost Estimates
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of...
2013-09-11
1,733 reads
Managing Data in a FileTable with T-SQL
I wrote a post about creating a Filetable, which just covered the basics of how to build one. How do...
2013-09-11
1,090 reads
MCM on Life Support
Good news everybody. October 1st is no longer the day that the MCM was prescribed to die. The Microsoft Certified Master is now on life support until December 31st,...
2013-09-11
5 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
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