Alter Datatype of All the Columns In Database
Requirement: Recently we got the information from management
that our project will be getting the customers from China, so our application
should...
2017-03-28
149 reads
Blog Posts
Azure – SQL Database Premium RS
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...
2017-03-28
989 reads
Data Channel - Interview 04 - Martin Catherall on In Memory OLTP
Welcome to the 4th Interview of Data Channel. We have Mr.Martin Catherall, 3 time Data Platform MVP from Australia / New Zealand discussing "In Memory OLTP" tables. Interview was...
2017-03-28
6 reads
Data Channel - Interview 04 - Martin Catherall on In Memory OLTP
Welcome to the 4th Interview of Data Channel. We have Mr.Martin Catherall, 3 time Data Platform MVP from Australia / New Zealand discussing "In Memory OLTP" tables. Interview was...
2017-03-28
10 reads
How is easy to work with JSON in SQL SERVER 2016 ?
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,529 reads
Sharing With You In All Fifty States
I made a mistake the other day. For some reason I got it into my head that I was flying...
2017-03-28
447 reads
SQL Saturday South Island, New Zealand (SSSI)
TweetG’day,
Saturday 8th April 2017 will see the biggest ever SQL Saturday South Island New Zealand. The event started in 2013...
2017-03-28
954 reads
SQL Server 2016 – Always Encrypted and the GDPR
The European General Data Protection Regulation (GDPR) is coming, bringing new rules about the protection of Personally Identifiable Information (PII).
For...
2017-03-28
5,637 reads
SQL Server Database Recovery Process Internals – database STARTUP Command
A database recovery process is an essential requirement for database systems, It can be a tedious job and the process...
2017-03-28
592 reads
SQLSaturday Madison – April 7-8
The first event I ever spoke at was SQLSaturday in Madison, Wisconsin, back in 2012. I was petrified – would anyone...
2017-03-28
382 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