Azure DWH part 22: Dynamic Management Views
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
2017-12-26
918 reads
Articles
Query Plan Oddities: Two Identical Missing Indexes
Brent demos a single query plan that asks for 2 identical indexes on the same table.
2017-12-26
3,142 reads
The Case of the Shrinking CFO, err Database
Shrink SQL Server databases quickly and with virtually no contention.
2017-12-25 (first published: 2015-08-17)
4,354 reads
Why Haven’t You Upgraded SQL Server?
Kathi Kellenberger wonders what's keeping your business from upgrading.
2017-12-25
63 reads
Cascading Update and Delete for SQL Server 2017 Temporal Tables
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
2017-12-25
3,228 reads
Securing Reporting Services Reports
Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.
2017-12-22 (first published: 2010-05-18)
8,279 reads
New Azure SQL Database Standard Tier Sizes
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.
2017-12-22
3,997 reads
Different Ways to Find SQL Server Orphaned Users
SQL Server orphaned users are a common thorny issue in auditing. In this post, Jeffrey Yao provides a few different ways of identifying orphaned users covering various scenarios.
2017-12-21
3,707 reads
Still More SQL Server Features that Time Forgot
As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been removed from recent versions of SQL Server. In some cases, the features were widely used and often loved, while others had lost their usefulness over the years or were replaced with something much better. In this article, he remembers Data Transformation Services (DTS), a handful of DBCC commands, a few utilities, Active Directory Helper Service, English Query, Web Assistant, SQL Mail, Native XML Web Services, Notification Services, SQL Distributed Management Objects, Surface Area Configuration Tool, and the Pubs and Northwind databases.
2017-12-20
3,745 reads
Azure DWH part 21: Using Excel in ASDWH
This time we will show how to access to Azure SQL Data Warehouse using Excel.
2017-12-19
599 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Automating Database Cleanup for PostgreSQL Using Python
Comments posted to this topic are about the item Automating Database Cleanup for PostgreSQL...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers