Privacy and Data
Much of the data collected by companies is being sold for profit. This data isn't treated well and while not much may change, perhaps we should be aware of how we handle data as professionals.
The PoSh DBA – Specifying and Gathering Performance Counters
If you need to keep tabs on a number of servers and applications in a Windows domain then performance counters provide the bedrock of information. It is important to identify the counters you need and gather baseline data to allow you to create alerts when abnormal conditions occur.
Microsoft SQL Server 2014 released to manufacturing
, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will be generally available on April 1.
Review Your BUCKET_COUNT Statistics with DMV
Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.
Creating a Date Range from Multiple Rows Based on a Single Date
When you've got only a single effective date on a record and you need to artificially create the effective end date based on a following row in T-SQL, the techniques discussed in this article will help you decide what is best.
SQL Server Luxembourg: Natural Born Killers
The SQL Server Luxembourg user group will be meeting on March 26. This is a free event for all registered attendees, and will feature Richard Douglas and Tom Van Zele as speakers.
Paul Randal: Geek of the Week
Paul Randal and Kimberly Tripp, together with their small team of experts at SQLSkills.com, dominate the high-end training and consultancy for SQL Server. We sent Richard Morris to find out a bit more about Paul, his views about SQL Server, his lifestyle, ambitions and plans.
Getting Started with Azure
Many people have been unsure of cloud computing and what it means for your particular application. Steve Jones notes there's a great new demo that can help you get started exploring the Azure offerings.
How Many Passwords?
How many passwords do you have? Steve Jones has a lot and while he notes there are some new ways for us to authorize ourselves for servers, they aren't necessarily making things more secure or less complex.
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