SQL , Lift up your heads for the cloud - Azure SQL
In my journey with Azure SQL Server I am often asked.1) Why should I move to cloud ?2) Which model should I go for ?3) What do I need...
2019-12-03 (first published: 2019-11-23)
639 reads
I’m Speaking at #SQLSatDC
I am so excited to announce that I will be speaking at SQL Saturday DC on Saturday, December 14, 2019. I am so honored to have been selected. This...
2019-11-23
29 reads
Back for More with SQL, Azure, Machine Learning, Big Data!!!!
Let me start with an apology for being missing so long 🙂 Guess was trying to find where technology takes me as I started my journey with pool of...
2019-11-23
198 reads
How Many Bytes Per Character in SQL Server: a Completely Complete Guide
A Completely Complete Guide to how many bytes are used to represent characters in the T-SQL string datatypes… Continue reading How Many Bytes Per Character in SQL Server: a...
2019-12-04 (first published: 2019-11-22)
3,965 reads
Power BI Monthly Digest – November 2019
In this month’s Power BI Digest Manuel Quintana [Blog | Twitter] and Mitchell Pearson will again guide you through some of the latest and greatest
2019-11-22
45 reads
Resuming Index Operations With Different Options
Starting with SQL Server 2017, Microsoft introduced the ability to pause and then resume index rebuilds. This was a great feature and with the release of SQL Server 2019,...
2019-11-22
44 reads
Data Masker Reads Column Classificiations
One of the newer features in Data Masker for SQL Server is the ability to read column classifications and suggest rules to clean the data. I decided to give...
2019-12-02 (first published: 2019-11-22)
281 reads
SQL Saturday Rochester Returns!
We have just published SQL Saturday Rochester 2020. We took last year off but we’re back for 2020 on a very special day - it’s Leap Day, February 29th!
What...
2019-11-22
18 reads
NTSSUG Board Elections
It is that time of year again. The NTSSUG has two spots coming open on the board. Last year I decided at the last minute to opt in as...
2019-11-21
15 reads
Dynamically Creating Azure Data Studio Notebooks with PowerShell for an Incident Response Index Notebook
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the point? What...
2019-11-21
34 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers