The Good The Bad and The SLA
Lets just get straight to the point, Azure SQL Database across all service tiers gives you the customer a SLA...
2018-08-20
255 reads
Arun Sirpal
SQL Reserved vCores
Have you ever heard of SQL Reserved vCores? Well I never until recently. With this concept you have the ability...
2018-08-16
341 reads
Azure SQL DW – Query Labels
Using a query label in Azure SQL DW (Data Warehouse) can be a really handy technique to track queries via...
2018-08-14
356 reads
Azure SQL Data Warehouse and Backups
Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills...
2018-08-07
411 reads
SQL Server – Blocking a Truncate
The truncate option is fast and efficient but did you know that it takes a certain lock where you could...
2018-07-31
546 reads
PsPing your Azure SQL Server
PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to...
2018-07-23
650 reads
SQL Agent for Azure SQL Database? Not quite
The following post shows my preferred way to automate / schedule some code against my Azure SQL Database. No it is...
2018-07-16 (first published: 2018-07-09)
2,391 reads
Azure SQL Elastic Pools – Moving Databases
If you read official Microsoft documentation about naming conventions for your SQL elastic pools, it is hard to find any...
2018-07-09 (first published: 2018-07-02)
1,946 reads
Azure SQL DB – Login failed for user NT AUTHORITY\ANONYMOUS LOGON.
Now that I have your attention with a powerful title how about some context? It is quite common to get...
2018-06-26 (first published: 2018-06-15)
2,300 reads
SQL Server 2017 – SELECT INTO [A SPECIFIC FILEGROUP]
Forget about Adaptive Query Processing for a minute, what other feature have I been waiting for? SELECT INTO a specific...
2018-06-19
575 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
The Improvement Limit
Comments posted to this topic are about the item The Improvement Limit
Migrate SSRS Reports to a New Server in Just a Few Clicks
Comments posted to this topic are about the item Migrate SSRS Reports to a...