A Tail Log Needs a Clean Shutdown
Someone posted a note asking how they might restore if the disk that contained their transaction log crashed. I replied...
2010-08-09
413 reads
SQL lunch #28-SSIS Design Patterns 1a: Introduction to SSIS Design Patterns
In this three part series SQL Server MVP Andy Leonard will discuss SSIS Design Patterns.
Speaker: Andy Leonard
Add To Outlook:...
2010-08-08
1,073 reads
sp_help_partition
If you are using partitioned tables, this may come in handy. I’ll keep it short and just post the code....
2010-08-08
1,747 reads
RE: Contract Coding: Ensuring your Client pays up (great article from Damon Armstrong)
I am very happy to see Damon Armstrong take up this touchy subject in Simple-Talk.com `s Opinion section. Worth a...
2010-08-08
535 reads
SQL Server Magazine 2010 Community Choice Awards
Nominate your favorite products for the SQL Server Magazine 2010 Community Choice Awards. August 24th Deadline for Nominations...
SQL Server...
2010-08-08
1,525 reads
devLINK a Huge Success
Where can you spend $100 and get three full days of technical training? devLINK of course. devLINK 2010 was held...
2010-08-08
512 reads
More Videos from SQL Saturday
With everyone geared up for SQL Cruise I’m surprised we can air this video but since we kicked it off...
2010-08-07
203 reads
SQL Saturday 40 – Behind the Music
Ok folks, the video from SQL Saturday 40 is finally up. Thanks to the sponsors who helped foot the bill...
2010-08-07
276 reads
SQL Server Object Dependency Viewer Revisited
A year ago I blogged about building a SQL Server 2008 Object Dependency Viewer based on a script by PowerShell...
2010-08-07
1,695 reads
Difference between Mirroring and Log Shipping
It’s been quite some time that I blog, Sorry about that I was busy with my movement from USA to...
2010-08-07
859 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
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...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
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