How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
2010-05-11
9 reads
Blog Posts
Is Pivot Worth it?
I’ve been trying to learn more about the T-SQL changes in SQL Server 2005/2008 over time. I don’t have requirements...
2010-05-11
665 reads
Join the Community - AKA, "Where did he go, George?"
In recent days I've kind of dropped off the map with respect to SQL Server, including with the Security and...
2010-05-11
762 reads
May UG Meeting
This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this...
2010-05-11
468 reads
Minutes of the April 2010 PASS Board Meeting Published
This was a phone meeting on April 8th, 2010, that covered:
Possibility of an online track at the 2010 PASS SummitDiscussion...
2010-05-11
690 reads
Minutes of the February 2010 Board Meeting Posted
Strangely we’ve had the March minutes up for many weeks, but just now getting the February minutes posted. This was...
2010-05-11
601 reads
Notes from the May 6th, 2010 oPASS Meeting
We moved to Thursday this month to line things up so that Dean Richards from Confio could do a presentation...
2010-05-11
548 reads
Put your left LOB in, put your left LOB out…
It’s time again for T-SQL Tuesday and this month the topic is LOB, or BLOB data. You can read more...
2010-05-11
1,915 reads
Recompiles and Constant Learning
When faced with a procedure that looks like this:
CREATE PROCEDURE dbo.TestProc (@TestValue INT)
AS
BEGIN
IF @TestValue = 1
BEGIN
SELECT *
FROM Sales.SalesOrderHeader AS soh
JOIN Sales.SalesOrderDetail...
2010-05-11
773 reads
Simple Production Script Auditing Best Practices: Including Query in the Result Set
To make it easier for others to audit the results of a script you have run on current production servers,...
2010-05-11
1,486 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
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