How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation.
SELECT @@SERVERNAME...
2014-07-17
1,871 reads
Blog Posts
Modeling the Agile Data Warehouse with Data Vault – Review
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a...
2014-07-17
1,744 reads
SSC Editorial: Access Disdain
Contrary to the title (by design), Access Disdain is about not automatically hating Access (or it’s users). Clearly Access has...
2014-07-17
623 reads
SSIS: Value does not Fall Within the Expected Range
Every now and again I find myself working with SSIS for one reason or another. Every now and again I find myself fighting with SSIS because it provides less...
2014-07-17
44 reads
Building The SQLSaturday Orlando Marketing Plan-Part 23
Here’s the latest update on our registrations. We’re still ahead of all our previous events, that’s good, and we’re 2...
2014-07-16
573 reads
IT books that should be on your shelf
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting....
2014-07-16
1,214 reads
Presentation to the Baltimore SQL Group on July 15, 2014
I did an online presentation about PCI and Credit Card Security for BSSUG last night and it went pretty well,...
2014-07-16
674 reads
Remembering Reed Jacobson
I just received some bad news and found out that a friend passed away today. Reed Jacobson was one of...
2014-07-16
505 reads
So Long and Thanks For All The Fish
Not to try and steal Satya Nadella’s thunder today at WPC but I’ve got some exciting news of my own to share. I’m excited to say that I’ll be...
2014-07-16
3 reads
So Long and Thanks For All The Fish
Not to try and steal Satya Nadella’s thunder today at WPC but I’ve got some exciting news of my own...
2014-07-16
381 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
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
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