SQLTreeo resurrection
I would like to inform you that I transferred all activities around SQLTreeo SSMS Add-In to couple of persons who...
2012-09-21
769 reads
Blog Posts
Transact-SQL analytic functions in SQL Server can help solve problems quickly
Like other mainstream commercial database systems, SQL Server supports analytic functions in Transact-SQL to depict complex analytical tasks. With the...
2012-09-21
1,530 reads
Upgrade SQL Server 2005 Full-Text Catalog to SQL Server 2012……By Detach & Attach…….Part 2 of 2
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
We have copied...
2012-09-21
994 reads
Verify those Backups
It’s important that you backup your database. The most important thing you can do. However making backups isn’t enough: you...
2012-09-21
873 reads
24 Hours of PASS Fall 2012
Do you like training? Do you like FREE training? Then make sure you check out the 24 Hours of PASS...
2012-09-20
1,288 reads
Interesting Reading for September 18, 2012
More stuff you may find interesting.
Prepare for your first security breach. Sobering. As data professionals we’re going to get pulled...
2012-09-20 (first published: 2012-09-18)
2,132 reads
Join Our Networking Dinner in Seattle
This is the third year that Andy Warren and myself are hosting a networking dinner in Seattle, just before the...
2012-09-20
1,151 reads
Parsing Windows event logs with PowerShell
Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possibly adding that...
2012-09-20
7,497 reads
SQL Server 2012 Upgrade
SQL Server 2012 has been in RTM since the 1st April 2012. Many of my clients have been evaluating the...
2012-09-20
1,107 reads
tablediff Utility
I recently stumbled across a little gem of a utility called tablediff. I have been working a lot with replication...
2012-09-20
6,690 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers