Answering SQL Questions and Forum Fun Overview
Why SQL questions are interesting and how I'm using forums to challenge myself and help others.
I like a good SQL...
2011-05-19
654 reads
Fun with SQLskills
I’m in a fun mood today, so a few silly items for you.
The last few weeks, Paul Randal (blog | @PaulRandal)...
2011-05-18
897 reads
Summit Preference Voting
This year the PASS organization is asking us to vote on the PASS Summit 2011 sessions, not as a means...
2011-05-18
736 reads
New Microsoft BI Labs site
Interesting new BI site from Microsoft called “BI Labs“. This site says: “BI Labs is a collection of experimental business...
2011-05-18
1,121 reads
The Recursive CTE
(Yet another boring org chart example – except this one has multiple roots)
One of my apps has a hierarchial org chart...
2011-05-18
1,710 reads
PASS Summit Session Votes
I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point...
2011-05-18
1,082 reads
How To Make Your Laptop 100x Faster
Simon Sabin had his own take on increasing laptop speed. He had some good ideas, but he inspired me to...
2011-05-18
2,337 reads
How To: Use the Same Data Flow Column Twice As a Parameter in SSIS
Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. You'll use an UPDATE statement or a destination table that needsto use...
2011-05-18
14 reads
How To: Use the Same Data Flow Column Twice As a Parameter in SSIS
Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. You'll use an UPDATE statement or a destination table that needsto use...
2011-05-18
21 reads
How To: Use the Same Data Flow Column Twice As a Parameter in SSIS
Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. ...
2011-05-18
1,385 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers