So you’re hosting your SQL Server in the cloud, and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems - what's going on? Brent Ozar explains.
ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?
On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.
Power BI has a lot of uses, but one of the most interesting of them is to model and shape data to make it easier for self-service BI. Power BI is a full-stack solution that includes data loading, data modelling, metrics, reporting and distribution. It can take the source data, and perform in-process data modelling relatively easily as well a providing an easy to use and powerful user interface for analytics and reporting.
Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.
This week Steve Jones has a bit of a competition. Share with him how fast you can back up a 1TB database.
Developing JavaScript for web pages can be perplexing. You will get errors that seem to make no sense, You will be given nuggets of advice about how and when you can use JavaScript to manipulate the DOM or make Ajax requests. It is far better to understand the reason for these rules; the single-threaded nature of JavaScript, and how it loads the page and manages the event loop. How can you achieve parallel processing and what is the best way? Igor makes it all clear and obvious.
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
Erik Darling looks at SET STATISTICS TIME ON and SET STATISTICS IO ON as potential tools for troubleshooting a query.
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers