SQL Cruise Mediterranean+
This is a post that is looooong overdue. I have intended to write some of this at least since the...
2015-06-24
664 reads
Which user function do I use?
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you...
2015-06-30 (first published: 2015-06-24)
2,092 reads
SQL Code Guard - Developer build: just as planned
Well, not exactly just as planned, but at last!
Few minor fixes
[*] fixed unparsed with CONTAINS condition[*] fixed xtra "ST010 Use...
2015-06-24
618 reads
Some simple examples of querying xml with sql
XML is a beast if you’ve never tackled it. Here are some simple examples of what I discovered as I...
2015-06-24
291 reads
Leveraging SQL Server Database Schema
Leveraging SQL Server Database Schema
Data warehouses typically pull data from various sources and combine the data into a common repository....
2015-06-24
684 reads
Exams 70-457 & 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012
This past week I finally completed the 70-458 exam to upgrade my certification to MSCA: SQL Server 2012. I never...
2015-06-24
733 reads
MSSQLTips / Tegile Systems Webinar Wrap up
Thank you all for attending my MSSQLTipswebinar today with Sumeet Bansal from Tegile Systems! In the presentation, I made reference to...
2015-06-23
624 reads
Our Meeting and The Day Out
Last week, Redgate Software had a large company meeting and our annual Day Out, with myself and a few dozen...
2015-06-23
708 reads
Precon in Columbus OH
I’ll be doing a precon for SQLSaturday #421 in Columbus Ohio on July 10th, 2015 titled “Planning a High Availability and Disaster...
2015-06-23
423 reads
SSC Editorial: Sweat Files and Practice Projects
Published last week on SQLServerCentral, Sweat Files and Practice Projects is about the need/lack of packaged projects that a newbie...
2015-06-23
340 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