Why Would I Want to Use JSON in SQL Server?
SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...
2016-09-04
648 reads
SPACE
USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...
2016-09-04
194 reads
STUFF
Use case when we are working on TSQL or Query ,some time we came such a situation when we need...
2016-09-04
189 reads
DAX Date Dimension and Fun with Date Math
I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...
2016-09-03
654 reads
How to Resume Suspended Database Mirroring in SQL Server ?
Overview
Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and...
2016-09-03
103 reads
How to Resume Suspended Database Mirroring in SQL Server ?
Overview
Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The...
2016-09-09 (first published: 2016-09-03)
11,178 reads
TGI SQL Friday - Weekly Roundup 2nd September 2016
Weekly Summary
Last week I was holiday in Cyprus. The weather was plus 30 degrees celsius all week. The pool was...
2016-09-02
525 reads
SQLMonitor Adds Graphical Query Plans!
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More fixes and more features. In this latest release, they...
2016-09-02
14 reads
SQLMonitor Adds Graphical Query Plans!
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More...
2016-09-02
480 reads
SQL Saturday Charlotte is Coming!
That’s right, SQL Saturday Charlotte is coming September 17, 2016. Next to the annual PASS Summit, this is my favorite...
2016-09-01
393 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers