Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...
2014-08-11 (first published: 2014-08-04)
8,822 reads
Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"
The answer is as simple as...
2014-07-22
497 reads
Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...
2014-07-07
662 reads
Imagine that you have a huge collection of Hello Kitty images (I do).
One day you make a decision to organize...
2014-06-30
1,934 reads
Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...
2014-06-23
748 reads
When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...
2014-06-17 (first published: 2014-06-15)
3,609 reads
Imagine that you have a table of customers
createtable Customer
(
Name varchar(30),
LastName varchar(30),
Title varchar(30)
);
go
insertinto Customer values('Alex','Smith','Mr.');
insertinto Customer values('John','Doe','Dr.');
goNow you selecting list...
2014-06-10 (first published: 2014-06-09)
1,884 reads
It may happenthatyou have a needto check thescripts thatyou have on yourdisk. For example, it may be part of yourbuildprocess.So how...
2014-06-02
1,839 reads
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
689 reads
Today we released new version of SQL Code Guard, 2.5.5257
Main changes:
SQL Code Guard is digitally signed now to satisfy corporate...
2014-05-26
779 reads
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Comments posted to this topic are about the item Removing TDE
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers