New Truncation Error Message in SQL Server 2019
A new error message in SQL Server 2019 will make your life much easier!? Learn more...
2019-03-05
3,244 reads
Additional Articles
Protecting Credit Card Data when Testing
Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can help you protect credit card data while maintaining characteristics and distribution of the real thing.
2019-03-05
2,916 reads
Apache Cassandra Data Modeling and Query Best Practices
Organizations have many choices when it comes to database platforms. Choosing the right one for an application should be based on the application’s characteristics and the platform’s features. In this article, Pushpa Sekhara explains why the Apache Cassandra database might be a good choice and how to get the most from it.
2019-03-04
2,398 reads
Getting Started with Power BI - Part 1
In this tip we will show how Power BI works and how to create a simple report from scratch and the options available for creating reports.
2019-03-01
5,579 reads
Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning
Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of these features.
2019-02-28
2,433 reads
Verify File Exists Using PowerShell
In this tip we look at a PowerShell script that can be used to compare actual files that exist against a list of files that should exist for a project to identify any missing files.
2019-02-27
3,120 reads
Getting Approximate Count in Microsoft SQL Server
Sometimes performance is more important than exact accuracy. Learn how to get an approximate count in SQL Server with better performance.
2019-02-26
5,395 reads
Introduction to SQL Server Security — Part 2
In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting permissions to users, logins, and groups.
2019-02-25
2,336 reads
What is the Best Value for Fill Factor in SQL Server
Learn about how selecting a SQL Server index fill factor can impact storage and performance. Check out the included scripts to help give you better insight.
2019-02-25
3,023 reads
An Introduction to GitHub for DBAs
Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved?
2019-02-22
3,826 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers