Watch Your DataTypes in Aggregates–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-29
1,003 reads
Blog Posts
What Is A Day?
When designing a data warehouse or reporting architecture, the smallest questions can pose some of the biggest challenges. Identifying what...
2017-03-29
613 reads
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
158 reads
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
992 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
16 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
8 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,538 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
449 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
964 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,646 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers