Take a deep dive into perhaps the single most important facet of query performance―indexes―and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other […]
2023-09-20 (first published: 2023-03-17)
2,917 reads
Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused.
2023-09-11 (first published: 2023-06-05)
2,433 reads
Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. ss
2023-09-08 (first published: 2023-05-08)
2,968 reads
2023-08-07 (first published: 2008-03-20)
2,999 reads
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.
2023-08-04
283 reads
To get the most out of your PostgreSQL database, find out the six performance metrics that ought to be central to your PostgreSQL monitoring strategy.
2023-07-03
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table. But let’s start from the beginning, by starting from the end.
2023-06-07
126 reads
Phil Factor offers straightforward answers to tricky SQL Compare questions.
2020-09-30
There is no good reason for having ANSI_PADDING set to OFF when you create tables in SQL Server. It was provided purely for legacy databases that had code that assumed the old CHAR behavior for dealing with padding, and its use has now been deprecated.
2020-03-18
You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.
2019-10-14
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Hi We have an stored procedure which runs frequently and it contain logic in...
Hi I am new to replication and we have database of size around 2TB...
I want to query a table that has a datetime column ([CreateDateTime]) and get...
Ask SSC