(Pinal Dave) Building a solution for some sort of disaster site is critical for every organization that thinks about business continuity. One of the proven for ages is a solution around Log Shipping. Though one of the oldest, it is one of the most sought after solution inside SQL Server.
Tag: sql server
Internals of the Seven SQL Server Sorts – Part 1
(Paul White) As far as graphical execution plans are concerned, there is just one icon for a physical sort in SQL Server:
SQL Server Data Tools (SSDT) is Missing After Installing SQL Server 2014
(Scott Murray) I installed SQL Server 2014, but now the SQL Server Data Tools (SSDT) application used to develop BI solutions in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS) is missing. How do I get the tools back?
SQL SERVER – Using MaxTransferSize parameter with SQL Server Backups
(Pinal Dave) Off late I have been writing a lot around SQL Server backups and administration topics. I have seen a lot of my readers have been enjoying some of the deep conversations I have with people in the industry.
In-Memory OLTP: Part 1 – Introduction
(DBAFromTheCold) In-Memory OLTP is getting a lot of (rightly deserved imho) hype at the moment. But what does it entail exactly? If you’re a DBA with a few years experience under your belt and are looking to get into this new feature but don’t have the time to sit and read the various technical arti
Finding Scalar Aggregate Indexed Views in Your Database
(Michael J. Swart) Fellow MVP Paul White recently blogged about a SQL Server bug. His blog post is called An Indexed View Bug with Scalar Aggregates
SQL Server Min Max Column Normalization for Data Mining
(Dallas Snider) In data mining, we often need to perform min-max normalization on numeric data type columns to prevent one column from skewing or dominating the models produced by the machine learning algorithms.
Understanding Cross-Database Transactions in SQL Server
(Grahaeme Ross) When Microsoft introduced their ‘Always On’ technology, they made the statement in TechNet, which our team has since had confirmed, that they cannot support distributed or cross-database transactions (CDT) with Always-On Availability Groups because they cannot guarantee data in such
What is a CTE
(Kenneth Fisher) CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade. But even though they have been around for that decade and are widely used I still find that they confuse people somewhat.
User Login Permission Detail
(Stephanie Nguyen) Use this stored procedure to quickly capture all login information when needed, especially for security audit situations.