Building a SQL Server app? Start with Azure SQL DB.
No no, April Fool’s was yesterday. Hear me out. Azure SQL DB’s feature limitations are a good thing. It doesn’t support everything that SQL Server supports, like CLR, cross-database transactions, database mail, linked servers, and OPE …
SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution
Every time we talk about deadlock, you will see DBA frowning on this topic. DBA believes that Developers are creating the deadlocks and developers believe that DBA’s should be taking care of the deadlocks. Essentially, it is such a subject which …
Enforce SSL for connecting to AWS RDS Instance of SQL Server
The post Enforce SSL for connecting to AWS RDS Instance of SQL Server appeared first on SQLServerCentral.
Security Considerations for ERP Applications
Did you know? eBay suffered a serious security breach in 2014 that led all 145m customers to change passwords to secure their accounts. According to research performed by the Ponemon Institute, the average cost for a breach of sensitive data in 2018 is …
Registration Open for SQL Saturday Stockholm Workshop 2019
I am super excited that I will be visiting Stockholm SQLSaturday 2019. I will be delivering a day-long pre-conference on my most popular workshop – 21 Essential Scripts: Performance Tuning for EVERYONE. 21 Essential Scripts: Performance Tuning fo …
SQL Server 2019 Adds CosmosDB Support
SQL Server 2019 is already looking to be one of the major releases of the platform with quite a few enhancements. The addition of Big Data Clusters, Accelerated Database Recovery, and Java programmability, many organizations will be considering the mov …
Customizing Statistics Histogram in SQL Server 2019
The post Customizing Statistics Histogram in SQL Server 2019 appeared first on SQLServerCentral.
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218
Question: How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? Answer: I must admit, I had to do search the internet for this answer. I had no idea how to answer this question. I was initially asked this question during the Comprehen …
Consulting Wrap Up – What Next and How to Get Started
This is the wrap up post of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it …
Consulting 105 – Why Don’t I Want My Customers to Return for the Same Problem? – SQL Server Performance Tuning
This is the fifth of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it my busi …
SQLServerCentral v3 coming tomorrow
SQLServerCentral v3 Coming Tomorrow, Mar 30. We will release the next version of SQLServerCentral, tomorrow, March 20, 2019. There will be a brief period of downtime in the morning (9-10am UTC) as we perform a final incremental database migration of ch …
Getting Started with Azure Data Studio and SQL Server 2019 Preview
SQL Server 2019 is in the final rounds of Community Technology Previews, and if I wasn’t excited about it before, I definitely am now.
How to Prepare for SQL Server 2008 and 2008 R2 End of Support
Microsoft is set to end support for SQL Server 2008 and SQL Server 2008 R2 in July. Are you ready?
SQLintersection Spring 2019
As we head towards our SQLintersection Spring 2019 in June (our 13th show), I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is that att …
Registration Open for My SQLSaturday Sacramento Workshop
I’m coming to Sacramento this year for SQLSaturday #885. On Friday, I’ll be teaching a one-day pre-con: Performance Tuning in 21 Demos – You’re a developer or DBA who wants to tune indexes and queries to make your applicati …