Modernizing Your T-SQL: String Aggregation
This is another in a group of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
SQL Server 2016 gave us the STRING_SPLIT() function,...
2020-02-18
3 reads
Blog Posts
Using Google Chrome with SSRS
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
The post Using Google Chrome...
2020-02-18
37 reads
Using Google Chrome with SSRS
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
2020-02-18
8 reads
AWS RDS SQL Server Announcements - 2020
1. Amazon RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts and VPCs using Managed Microsoft AD: https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-joining-domain-across-aws-accounts-and-vpcs-using-microsoft-managed-ad/
2020-02-17
38 reads
AWS RDS SQL Server Announcements - 2020
AWS RDS SQL Server Announcements - 2020
1. Amazon RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts and VPCs using Managed Microsoft AD: https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-joining-domain-across-aws-accounts-and-vpcs-using-microsoft-managed-ad/
2. Amazon RDS for SQL...
2020-02-17
8 reads
SQL Undercover TV – Instant File Initialisation
Adrian has a look at the performance benefits of instant file initialisation Below is Ade’s auto growth script…
2020-02-17
33 reads
Starting and Stopping SQL Server with PowerShell
Have you ever had this issue? You are trying to explore new features of SQL Server or you want to install the latest version for some testing, but SQL...
2020-02-17 (first published: 2020-02-10)
2,170 reads
T-SQL Tuesday 123: Life Hacks to make your day easier
This month’s T-SQL Tuesday is hosted by Jess Pomfret. Jess’s theme is ‘Life Hacks to make your day easier’. She talks of some things we do to make life...
2020-02-17 (first published: 2020-02-11)
808 reads
Ethics in Modern Data presentation at SQLSaturday Austin BI Edition 2020
Excited to launch another new presentation, the first co-presented with my wife, on Ethics in Modern Data. We'll explore the ethical considerations around historical bias, ethics in analysis and...
2020-02-15 (first published: 2020-02-08)
208 reads
Asciidoc Distributed Docs as Code
TEST The Problem
I want to keep my code and my documentation in the same place.
I want to separate the presentation layer from my documentation content.
I want to be flexible...
2020-02-14
36 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers