Writing the Correct Query is Important
Making simple mistakes in queries can have far reaching consequences.
Free Webinar – Database DevOps Demo
Learn how to extend DevOps practices to SQL Server databases in our free demo webinar on January 17th. Microsoft Data Platform MVP, Steve Jones will demonstrate how Redgate’s database automation tools plug into Git, Jenkins & Octopus Deploy. Learn how to branch and merge with SQL Source Control then automate the build and deployment of changes with DLM Automation. Register now.
Using Power BI Desktop to Visualize SQL Server Metadata
You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create reports that you can then publish to others, and which allow drill-down. It is a great way to get familiar with PowerBI Desktop as well. Rob Sheldon shows how simple it is to do.
Scrubbing Personally Identifiable Information
Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.
Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster
A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.
Backing Up SQL Server Databases is Easier in PowerShell than T-SQL
Learn how easy the new SQLServer module makes backups of SQL Server databases.
Backup Data Security
We need better security for our data, especially for our choices in managing data.
Identifying Last Night’s SQL Agent Job Failures
Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.
Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE
U-SQL introduces two new data types - SQL.ARRAY and SQL.MAP. Here, we look at what we can do with SQL.ARRAY and the CROSS APPLY EXPLODE expression.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers