Tip: COLLATE for “Cannot resolve collation conflict” error
Some data professionals are VERY well versed with collation, and some never ever have to touch the concept. That second...
2014-03-17
570 reads
SQL Awesomesauce
SQL for Everybody
I read a terribly excited blog this morning by a guy who had just discovered Alt-F1 in SSMS. (If you don’t...
2014-03-14
642 reads
Bad Ideas: Alert Storming
Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do...
2014-03-10
674 reads
Configure static or dynamic IP and DNS with Powershell
I work in a lot of different offices and conference venues, in addition to my home office. At home, I need a...
2014-03-03
877 reads
Expiration dates: SQL Server 2008 and 2008 R2
SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support...
2014-02-24
579 reads
Home Workspace: Standing Desk
Ever since I worked in an office with adjustable standing desks, I’ve been thinking about getting a standing desk for...
2014-02-17
489 reads
What’s the CPU usage on the server? Use #Powershell!!
We have here an easy, handy-dandy way to find out how much CPU is in use on your server. Of...
2014-02-10
561 reads
Blockades and ladders to learning new tech
It’s been a long time since I’ve been a true newbie to a technology. There are plenty of things I...
2014-02-03
590 reads
Applied SQL: LIKE ‘whatever’
Today let’s play around with the LIKE operator. Like, totally. Like, Introduction Like “determines whether a specific character string matches...
2014-01-27
744 reads
Tip: Jobs without a scheduled run
It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be...
2014-01-22
537 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers