Can We Please Stop Sending Passwords Over the Wire?
While analyzing SQL Server’s network protocol, I came across a weird fact: when a database client logs in using SQL Server authentication (as opposed to Windows authentication), it has to send the user’s password to the server, in blatant violation of …
Eight Azure SQL configurations you may have missed
The post Eight Azure SQL configurations you may have missed appeared first on SQLServerCentral.
Join us at SQLBits, March 8-12
The post Join us at SQLBits, March 8-12 appeared first on SQLServerCentral.
Building PollGab.com: Designing the Data Model
In the last post, I talked about how Richie and I sketched out the goals of PollGab.com, the site where you can post questions for other folks to answer during their live streams. I challenged you to decide: What data needs to be stored to make all thi …
Building PollGab.com: Design a Database for Live Session Questions
Years ago when we did online presentations or live Office Hours webcasts, attendees would type their questions into the “Questions” section of whatever webcast platform we were using – WebEx, GoToWebinar, Zoom. This sucked because: Pe …
Creating an SSRS Report from an Azure SQL Database
Introduction This article is an introduction to creating an SSRS Report from Azure SQL. SQL Server Reporting Services (SSRS) is still a popular tool to generate reports. It is true that PowerBI is the most popular Microsoft reporting tool (yes, Excel i …
Power BI Designing with Diagrams
The post Power BI Designing with Diagrams appeared first on SQLServerCentral.
Can Continuous Compliance Automation transform data protection in your organization?
The post Can Continuous Compliance Automation transform data protection in your organization? appeared first on SQLServerCentral.
Big Data Clusters: Out of Aces
When this feature was announced in 2018, I wrote: <sarcasm> It’s like linked servers, but since they don’t perform well, we need to scale out across containers. </sarcasm> I just didn’t get it, and I continued: I like that …
Meme Week: Setting Fill Factor to Fix Fragmentation
I just shake my head when I see people setting fill factor in an attempt to “fix” fragmentation. The default fill factor is 100%. That means during an index rebuild, SQL Server packs 100% of your 8KB pages with sweet, juicy, golden brown an …
Frustrated with your database monitoring challenges?
The post Frustrated with your database monitoring challenges? appeared first on SQLServerCentral.
Sentiment Analysis with Python
The post Sentiment Analysis with Python appeared first on SQLServerCentral.
Chaos Engineering in Azure
Introduction Chaos engineering is all about breaking your application! It sounds counterproductive; however, it is the exact opposite. It is a methodology to test how resilient your application is in the actual production world. In this article, we wil …
Meme Week: NOLOCK? NOSQL.
When you find yourself using NOLOCK, consider NOSQL instead. NOLOCK has 4 big problems: Your query can see the same rows twice Your query can skip rows altogether Your query can see data that was never committed Your query can fail altogether If you …
Meme Week: SET DEADLOCK_PRIORITY HIGH
Hey, this seems harmless. Seriously, don’t SET DEADLOCK_PRIORITY HIGH. Even setting it to low can be a bad idea. I’ve heard people say, “Well, I’ve got a big process that runs nightly, but if it gets in anybody’s way, I wo …