Notes from My 24 Hours of PASS Presentation
Quick notes:
Because it was scheduled for 7 am local I decided to do it from home. Good plan, except it...
2012-09-21
820 reads
Blog Posts
PASS Elections 2012
Yeah, it’s that time again. And we have a magnificent slate of people running. I mean truly amazing and wonderful...
2012-09-21
701 reads
SQL Server Data Tools (SSDT) – September 2012 update
SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 11.1.20225). The SSDT team...
2012-09-21
1,593 reads
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
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
993 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,131 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
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Does factory reset get rid of viruses on Android and iPhone devices?
A factory reset will also eliminate viruses and malware on both Android smartphones and...
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers