This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.
Get ready to meet Microsoft's experts on-site in the exhibit hall and in multiple educational sessions (including a pre-con, keynote and learning pathway). Watch a sneak peek of Microsoft's learning pathway 'Becoming an Azure SQL DBA – Advancing the Role of the On-Premises SQL Server DBA'
Adding a new shared disk to Windows Server failover Cluster is not a complex process but special care must be taken when you want to use the new disk for any existing SQL Instance. In this article, we will show you all the required steps to add the disk to WSFC and then to properly assign it to an existing SQL role in the WSFC.
Learn how to create a backup of an AWS RDS for SQL Server database and download the backup file to use on another SQL Server instance.
Connect, share and learn with the global data community in Seattle this November. Whether you're a DBA, Developer, Architect, Engineer or you're just getting started in your data career, there's a huge range of content for you to choose from (over 150 sessions and counting across 5 different tracks). Speakers this year include Steve Jones, Grant Fritchey, Ryan Booz, Bob Ward, Deepthi Goguri and Jennifer Stirrup. Check out the full program and register before September 18 to secure your ticket at the standard price.
Today Steve wonders if you have simple solutions you like or complex ones you don't.
A list of articles in my series on Azure Data Studio along with a few other links.
Three new speakers will be taking to the stage at this year's PASS Data Community Summit for the New Stars of Data Track. Sessions will be delivered by Haripriya Naidu, Vitalija Bartusevičiūtė, and Jarid McKenzie!
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Hi all, I recently moved to a new employer who have their HA setup...
Comments posted to this topic are about the item Semantic Search in SQL Server...
Comments posted to this topic are about the item Encoding URLs
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers