A New Beginning
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
2009-12-31
2,194 reads
Articles
Connection strings for SQL Server 2008
A set of different connection strings for using with different providers for SQL Server.
2009-12-31
8,480 reads
Fun With DBCC FREEPROCCACHE
Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...
2009-12-31
15,057 reads
Using T-SQL to Transform XML Data to a Relational Format
More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.
2009-12-30
17,814 reads
Running a Small User Group - Getting Quality Speakers
Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia,...
2009-12-30
1,349 reads
The SQL of Scrabble and Rapping
In which Phil decides to use a table consisting of all the common words in English to explore ways of cheating at Scrabble and writing doggerel using SQL Server. He then issues a SQL challenge.
2009-12-30
3,255 reads
The Year in Review - 2009
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
2009-12-30
1,882 reads
The Year in Review - 2009
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
2009-12-30
2,385 reads
The Year in Review - 2009th
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
2009-12-30
2,204 reads
Scripting in SSIS – Part 1
Learning to script is a valuable skill for a DBA. Learning to script is invaluable for an SSIS developer and MVP Andy Warren starts a new series that examines the basics of adding scripts to your packages.
2009-12-29
13,783 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers