Basic XML Queries–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a question recently on querying...
2021-05-10
25 reads
Don’t Stop at Just Enabling Read Committed Snapshot Isolation (RCSI)
This past week I had a great Client ask an even greater question, and it got me thinking. The question is straightforward (albeit nerdy, which I love). “We’ve enabled...
2021-05-19 (first published: 2021-05-10)
915 reads
Query Compile Time
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-10
11 reads
Query Compile Time
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-19 (first published: 2021-05-10)
542 reads
Daily Coping 10 May 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-10
11 reads
New Blog post- Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
2021-05-09
11 reads
New Blog post- Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
2021-05-09
161 reads
Data Saturday #8–Southwest US
I am very excited to announce that I will be speaking for Data Saturday #8 – Southwest US, coming up on Saturday, May 15, 2021. I will be delivering...
2021-05-08
19 reads
Data Weekender v3.1
I am super excited about this new version of Data Weekender, coming up on Saturday, May 15, 2021. This will be the third time I have been selected to...
2021-05-08
28 reads
Azure SQL database security
In Azure database, security is managed through multiple-layers such as network layer, server layer and database layer. A secure blue print in deploying Azure SQL(more...)
2021-05-08
24 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers