(Pinal Dave) I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade.
Tag: sql server
SQL data classification – Add sensitivity classification in SQL Server 2019
(Rajendra Gupta) SQL Server 2019 offers powerful new features to help in safeguarding your data and complying with various privacy regulations, which we’ll be covering in this article
How to Aggregate an Archive Log’s Deltas into a Snapshot with SQL
(lukaseder) A customer of my popular SQL training (which you should book!) has recently challenged me to optimise a hierarchical query that merges an archive log’s deltas in order to obtain a snapshot of some record at a given point in time.
SQL Server Join Estimation using Histogram Coarse Alignment
(Paul White) The primary changes made to Cardinality Estimation starting with the SQL Server 2014 release are described in the Microsoft White Paper Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator by Joe Sack, Yi Fang, and Vassilis Papadimos.
Compare PUSH vs PULL Data Copy Performance in SQL Server
(Ben Snaidero) As SQL Server database professionals we are always tasked with moving data around. One of the methods I use quite often when copying data between instances (especially when it is just a one-off table copy between test environments) is to setup a linked server between the instances an
Azure SQL Database – Aborting Scale Request
(blobeater) Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy to do via the Azure portal or even PowerShell.
How to Encrypt SQL communication on the wire
(SanketBa) A lot of applications are moving to the cloud. The Iaas model provides a great way to lift and shift the applications and start leveraging the goodness of the cloud without having to re-write to adapt to the Platform-As-a-Service (Paas) model.
SQL SERVER – Unable to Start Service SQLSERVERAGENT on Server (mscorlib)
(Pinal Dave) There are several reasons for the error mentioned in the blog title. In this blog, we would learn about one of the causes of error Unable to start service SQLSERVERAGENT on a server.
The CredentialQuery Option For Web.Contents() In Power BI Custom Data Connectors
(Chris Webb) There’s a new, as yet undocumented, option for the Web.Contents() M function that is only available for custom data connectors and not in Power BI Desktop: CredentialQueryOption.
Audit Database Offline Events
(Jason Brimhall) Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important.