Raw Materials - Decisions, Decisions
Centuries ago, the philosopher Leibniz had a dream that all decisions could be made by machine. Today, his vision comes to life, more or less.
2012-01-05 (first published: 2010-06-23)
9,076 reads
Articles
Using bit columns with NULLs when three options exist in SQL Server
Frequently surveys ask yes/no questions and use a bit datatype. What are the effects of allowing this column to be NULL in a SQL Server table? Check out this tip to learn more.
2012-01-05
4,275 reads
XML-XSL Transformations in SQL Server
With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.
2012-01-04
7,772 reads
When to Break Down Complex Queries
Microsoft SQL Server is able to create very efficient query plans in most cases. However, there are certain query patterns that can cause problems for the query optimizer; this article describes four of these patterns.
2012-01-04
5,357 reads
Managing Transaction Logs
A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.
2012-01-03 (first published: 2008-10-31)
73,220 reads
2012-01-03 (first published: 2010-06-16)
9,172 reads
The XML Methods in SQL Server
The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and attributes within XML have been so foreign to the SQL language as to be somewhat of a barrier to their use. Fortunately, Robert Sheldon has once more managed to make the subject accessible to those of us who just need to get the job done.
2012-01-03
3,706 reads
Day Zero with PowerShell
Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server.
2012-01-02 (first published: 2011-05-10)
15,841 reads
SQL Server in Luxembourg
The SQL Server Luxembourg User Group will be holding its first major event of 2012 on Tuesday 17th January, starting at 4:30pm. The venue will be Microsoft's offices at Cloche d'Or.
2012-01-02
343 reads
Querying SQL Server Agent Job Information
Is there an easy/automated way to get information on SQL Server Agent jobs instead of connecting to each server and manually getting the information through the SSMS GUI?
2012-01-02
3,521 reads
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
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...
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