Microsoft has recently released a security patch for all supported version of Microsoft SQL Server. These updates are fixing where an elevation of Privilege vulnerability that could be exploited when an Extended Event session is running. From the Microsoft security bulletin: Data can be sent over a network to an affected Microsoft SQL Server instance that may cause code to …
Babelfish for Aurora PostgreSQLDecember 1, 2020Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of SQL Server to PostgreSQL or Aurora PostgreSQL can be challenging due to incompatibilities …Babelfish for Aurora PostgreSQLRead More » Sales To Aggressive?November 19, 2020When does a salesperson become too aggressive? In my business I try …
Amazon goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL. What is interesting is that a direct port of SQL Server to PostgreSQL or Aurora PostgreSQL can be challenging due to incompatibilities in data types, and in functions. What is promised in Babelfish is that it will create a layer between standard SQL Server TSQL and PostgreSQL to be …
Recently when shrinking a SQL Server data file, I ran into the following error: File ID 3 of database ID 15 cannot be shrunk as it is either being shrunk by another process or is empty. DBCC execution completed. If DBCC printed error messages, contact your system administrator. Before I get any grief about how bad shrinking databases is, and …
When building out a new SQL Server to replace an existing SQL Server, the previous system may have been using DTC or the Distributed Transaction Coordinator. This needs to be done on both sides of the transaction, meaning both servers that are participating in the distributed transaction. Next, right click on the Local DTC and select properties. On the third …
Configuring The Distributed Transaction Coordinator Read more »
One handy thing when working with JSON or XML is to take part of the data and represent it as tabular data, since everything in SQL Server works better as a table, pulling values out and representing them as a table can be handy. Going back to our original data as shown below from my original blog post that kicked …
Here is a recap of my last week of posts. Accessing XML and JSON contentJuly 3, 2020 Building on my earlier post of JSON and XML data, using the same table today we will take a look at accessing data. With that we can easily grab the entire XML document … Latest 100 Posts July is JSON and XML monthJuly …
Recently while working on a project I ran into the SQL Server Express File Size Limitation. After tracking it down I thought it would be worth documenting here for the next time someone needs this. Microsoft SQL Server 2005 Express edition has a database size limit to 4GB Microsoft SQL Server 2008 Express edition has a database size limit to …
As a DBA, what is the biggest problem or mess you have had to clean up in a SQL Server. If you have been a DBA for long enough, at some point you must have inherited a problem that someone else created, but it’s your problem to fix. I can think on several big problems, for instance one system that …
For me, I support SQL Server version from SQL Server 2000 all the way to SQL Server 2019 and Azure SQL. In a typical week I work on everything in between SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019 and Azure …