Estimated Number of Rows to be Read
Rob Farley uses this month’s T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explai …
SQL SERVER – Database mirroring connection error 4 – An error occurred while receiving data: 10054
I was trying to set up database mirroring in my freshly created Azure Virtual Machines and encountered an error. The error was talking about the connectivity problem, but it was something else. Let us learn about Database mirroring connection erro …
SQL SERVER – SQL Server: Getting OS information using DMV
I am used to exploring what is available in the technology of love – SQL Server. As I was exploring into one of the simplest set of DMVs which have been available for ages. There are several ways to get the OS information inside SQL Server. One o …
Azure Functions, Dapper and SQL Server JSON to store form data
A common problem Recently we had to setup a couple of contact form pages to allow users to register to the App 2.0 Beta program (now RTM) or to tell us which of the products we launched at CES 2017 they are interested into. Such kind of request are qui …
Introducing SDU Tools: Free T-SQL Tools for DBAs and Developers
I’ve worked with T-SQL for a very long time, and over the years I’ve lost count of how many tools I’ve found the need to create to help me in my work. They have been in a variety of script folders, etc. and whenever I go to use them n …
How to Enable Auto Update Statistics and Auto Create Statistics with T-SQL – Interview Question of the Week #108
Question: How to Enable Auto Update Statistics and Auto Create Statistics? Answer: I have received this question after watching my free webinar on group by conference by one of the user. I really loved his question so I am re-posting the question …
Intelligent Data Integration, SSIS Design Patterns, and Biml
On Friday, 24 Feb 2017, I have the privilege and honor of delivering a full-day precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration as part of SQL Saturday Boston . If you’re interested in learning more or attending …
SQL SERVER – Database Mirroring Connection Error 4 – An Error Occurred While Receiving Data: 10054
I was trying to set up database mirroring in my freshly created Azure Virtual Machines and encountered an error. The error was talking about the connectivity problem, but it was something else. Let us learn about how to fix the database mirroring conne …
SQL Saturday Pordenone is back!
Another SQL Saturday event has been scheduled in Pordenone (Italy), it will be the SQL Saturday #589 and this year it will be more international than the previous editions because the Data Science track will be completely in English language, as s …
On DevOps…
DevOps is getting a lot of attention in SQL Server and Developer communities these days. Two friends have blogged about the outage and accompanying data loss experienced by GitLab : Brent Ozar ( blog | @BrentO ) wrote SQL Server DBA’s Guide to th …
User Acceptance Testing and the Application Lifecycle
A software application can be robust, scalable, easily maintained, and easy to use, but if it doesn’t do what the customer needs then it is useless. The success of a new product or software application is at the mercy of how precisely it fulfils …
Memory Grants and Data Size
What does memory do? In SQL Server, just about everything. We cache our data and execution plans in it (along with some other system stuff), it gets used as scratch space for temporary objects, and of course queries use it for certain operations, most …
PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server
Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.
Is your SQL Server remote?
If the answer is yes, this survey is for you. Redgate is looking at building solutions to the issues associated with remote SQL Servers. They want to know your pain points, and whether there’s anything they can do to assist. If you think you could help …
Performance of the SQL MERGE vs. INSERT/UPDATE
The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?