Validate Integer and Decimal Values in SQL Server
Bhavesh Patel shows how to validate specific use-cases for integer and decimal values in SQL Server.
Comparing and Synchronizing Two Folders with Azure
In this article, we will compare two folders using PowerShell, the command prompt and other tools.
Azure SQL Database - Dynamic Data Masking
A number of security-related features are built into Azure SQL Database, including Transparent Data Encryption, Row-Level Security, and Azure SQL Database Auditing. Their availability reflects the consistent effort by Microsoft to provide functional parity between Azure SQL Database and SQL Server instances running in Azure virtual machines as well as in your on-premises environment. Another example of this trend is support for Dynamic Data Masking, covered in this article.
SQL Server Temporal Tables: How-To Recipes
Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 2016, make such tables behave like any other. How do you create one, or modify an existing table? How can you get an In-Memory Optimized OLTP table to be Temporal? Alex Grinberg shows how.
Combining R and SQL Server to diagnose performance bottlenecks
Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.
The Rate of Change of Data
Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.
Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot
When you are automating a number of tasks, or performing a batch of tests, you want a way of automating the production of your plots and graphs. Nothing beats a good graphical plot for giving the indications of how the process went. If you are using PowerShell and maybe also SQL Server, it pays to use a command-line plotting tool such as Gnuplot to do all the hard work. It turns out to be handy for a range of data jobs, turning PowerShell into a handy data science tool.
Using striped backups with SQL Clone
If you’re a Redgate SQL Backup customer, occasionally you’ll need to convert your SQL Backup (.sqb) files to the native SQL Server backup format (.bak), perhaps to perform native database restores on a server where SQL Backup isn’t installed. This produces a striped backup, because each thread used when making the backup will produce a separate file. Can we use a striped backup produced in this way, or indeed any striped backup, as the source for a SQL Clone image? Short answer: we can! Let’s see how that works.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
Alamat Bank BCA KCU MENARA BCA Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5,...
Alamat Bank BCA KCU THAMRIN Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec....
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers