Finding orphaned database users
Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the...
2011-10-20
21,481 reads
Blog Posts
Jeremy Huppatz presents Row Versioned Data Warehouse
Subject: Row Versioned Data WarehousesLevel: 200-300 (Intermediate)
Start Time: Thursday, December 15th, 2011 8:00 PM US Central Time
Presenter: Jeremy Huppatz...
2011-10-20
504 reads
PASS Board Of Elections: Adam Jorgensen
Be Part Of The Solution, Not The Problem
<disclaimer >
Now that BoD season is in full swing and I’m not running for...
2011-10-20
1,452 reads
Penance
Buck Woody wrote a fantastic post this morning for speakers to think about. All too often I have seen some...
2011-10-20
1,840 reads
Setting up SSIS Auditing Part 2
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...
2011-10-20
3,576 reads
SolidQ Announces BI Center of Excellence
Carl Rabeler, SharePoint and SQL BI Expert Formerly With Microsoft SQLCAT, Rejoins SolidQ as Director of the Business Intelligence Center...
2011-10-20
898 reads
sp_configure OR sys.configurations? and do you back these up?
G’day,
I was checking out some of our configuration options today using sys.configurations and I started to wonder how many people...
2011-10-20
6,774 reads
Todo lo que debes saber sobre SSIS en 1 hora!
Gracias a lo asistentes de mi charla Todo lo que debes saber sobre SSIS en 1 hora! en el evento...
2011-10-20
1,319 reads
Un-SQL Friday #006: Living in the Intertubez
We’ve had some BIG fun this week, relatively speaking, with #SQLSue and #SQLIdiot and just general #SQLcraziness. We’ve had several...
2011-10-20
598 reads
Virtual/Adhoc Teams
I’m a fan of virtual teams, times when you pull together people from across many teams to form a team...
2011-10-20
549 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