(Jason Thomas) Before I start, I want to make sure that everyone understands some points clearly:-
Tag: sql server
An Introduction to Cloud Computing …aligned with Microsoft Azure
(Manoj) Cloud Computing is the delivery of computing services like servers, storage, databases, networking, software, analytics and more-over the Internet (“the cloud”).
Data Encryption Using Always Encrypted in SQL Server
(Anoop Kumar) Data security is always a matter of concern for organizations and application users. The key challenge for any developer or architect is to understand all the concerns and build a foolproof system to ensure data security
How To Handle a Parent-Child Relationship in Analysis Services Tabular
(Koen Verbeeck) I have a table with a parent-child relationship: employees and their managers. I need to show this data using Analysis Services Tabular, but it doesn’t support parent-child relationships. Is there a work around?
Data Migration Assistant Custom Configuration
(Thomas LaRock) The Data Migration Assistant (DMA) is a great tool made available by Microsoft. Successor to the SQL Server Upgrade Advisor, the DMA will perform an assessment of your database against a target version. The DMA can also perform the migration of both schema and data, if desired.
Introducing SQL Information Protection for Azure SQL Database and on-premises SQL Server!
(Gilad Mittelman) We are delighted to announce the public preview of SQL Information Protection (Data Discovery & Classification), introducing advanced capabilities built into Azure SQL Database for discovering, classifying, labeling & protecting the sensitive data in your databases.
SQL SERVER – 2017 – Script to Clear Procedure Cache at Database Level
(Pinal Dave) When my customer ask they want to clear the cache of the database, I always so NO. It is not necessary. However, I have come to the realization that customers are always right and sometimes even though I say no, they still want to do it.
The world of Automatic Tuning – SQL Server 2017
(blobeater) Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged product. I was testing out SQL Server 2017 Automatic Tuning recently and I ended up with the following situation. Below shows an image from the query store.
When Using Availability Group Listeners, Why Can I See Non-AG Databases?
(Denny Cherry) Yep. This is actually by design; and is because listeners can be tricky little fellas. When using a SQL Server Availability Group Listener, you can see any databases on the server that is hosting the Availability Group Listener. The reason for this is because each SQL Server Availab
Backups of backups or How long is my backup really available?
(Kenneth Fisher) I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, and one of the most complicated. Take a full backup, restore it.
