SQL Server Management Studio v17.0
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
229 reads
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
229 reads
By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...
2017-05-03
91 reads
You’re reading this series of posts because you want to learn about databases and how to use them. What you...
2017-04-26
93 reads
Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming...
2017-04-19
112 reads
A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before,...
2017-04-12
100 reads
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
108 reads
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
311 reads
Last week, we discussed storing text in a database. This week we will dive deeper into data types. When storing...
2017-03-22
103 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
We have created a parent table, child table & Audit log table in SQL...
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers