Automatically Capturing SQL Server Performance Metrics
This article looks to provide a method that you can use to collect the author's top 10 SQL Server performance metrics automatically over time.
Hardware Hacking
Steve Jones examines one of the issues of foreign chip production: security. Will this be an attack vector in the future?
Hidden RBAR: Counting with Recursive CTE's
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
TSQL Challenge 62 - Break a long sentence in groups of 5 words
Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.
What SQL Server Books Do You Recommend
Brad's noticed that there are fewer good books about SQL Server on the shelves, and asks which books you'd recommend to people who are new to SQL Server
Adding the Script Task to Your SSIS Packages
Script tasks are a great way of extending SSIS functionality, when none of the built-in components are quite right for the task you need to perform. But how to go about creating a script task? No worries, once again Robert Sheldon is on hand to provide easy instructions on how to do it.
Free Two User License SourceGear Vault Professional
Read more about how you can get a free two user license from SourceGear and Red Gate Software.
Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
How to Compare the Data in Two Tables Without Any 3rd-Party Tool?
SQL Server ships with the tablediff utility which can be used to compare the data in two tables. Read this article to learn it step-by-step:
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers