When Do We Worry About Scalability?
Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.
Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.
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.
I'm excited to tell you about the "SQL from A to Z" learning track....
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
Comments posted to this topic are about the item The Cloud Security Problem, which...
http://servername/reports/browse/ could not load folder contents http://servername/reportserver The server principal "NT SERVICE\SQLServerReportingServices" is not...
I am planning to migrate a currently standalone database to SQL Always On. This...
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers