#SQLPASS #Summit14 Day 1 Keynote Highlights !
PASS President Thomas LaRock on stage !
PASS President Thomas LaRock kicked off the summit keynote.
Tom talked about the history of...
2014-11-05
877 reads
Blog Posts
Book: Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
I was fortunate to be a technical reviewer for a new book, SQL Server 2014 Business Intelligence Development by Reza...
2014-11-05
1,974 reads
Find all triggers in a SQL Server Database
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce business rules or...
2014-11-05 (first published: 2014-10-24)
23,169 reads
Generating T-SQL Randomly with Powershell
I have a lab on my laptop running various servers so that I can problem solve and learn and recently...
2014-11-05
548 reads
How to remove additional (unwanted) log files
Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a...
2014-11-05
1,134 reads
Live on PASStv
My session today at the SQL PASS Summit 2014 entitled “Right Sizing Your SQL Server Virtual Machine” is going to...
2014-11-05
407 reads
Multiple AGs
Today was my pre-con with Allan Hirt on AlwaysOn. It was great, and I learned a few things. I knew...
2014-11-05
684 reads
My 1st SQL in the City Experience !
I attended my 1st #SQLinthecity event hosted by RedGate yesterday. This is one of those events which I wanted to attend...
2014-11-05
990 reads
PASS Summit 2014 Day 1 Keynote Live Blog
This morning I will be live blogging the PASS Summit 2014 Day 1 keynote so those at home can follow...
2014-11-05
754 reads
PASS Summit 2014 Streaming Keynotes
Hello Dear Reader! It's that time of the year again, time for the PASS Summit and the streaming Keynote. Here...
2014-11-05
877 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