Assorted Links for April 27, 2013
Spend a few minutes reviewing 20 Critical Security Controls. Very interesting stuff. For example, #1 refers to having and maintaining...
2013-04-27
812 reads
Blog Posts
SQL Saturday 215 Deck and Demos Live
Hello Dear Reader! I'm up in Jacksonville for SQL Saturday 215. Today I'm presenting SQL Internals, Backups, and Recovery Models! OH...
2013-04-27
711 reads
A Rickety Stairway to SQL Server Data Mining, Part 11: Model Comparison and Validation
by Steve Bolton
Throughout this series of amateur self-tutorials on SQL Server Data Mining (SSDM) I’ve typically included some kind...
2013-04-26
2,687 reads
Choosing the Right Processor for your SQL Server Workload
Last year, we planned to move our data warehouse from a 2 socket server to a 4 socket server that was left in the data centre from an abandoned...
2013-04-26
13 reads
Does TDE really work on MDF files?
Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data:
-- create a...
2013-04-26 (first published: 2013-04-22)
3,442 reads
Gulf Coast SQL Server Users Group Wrapup
Today has been quite the day! This afternoon I presented for the SQL PASS Performance Virtual Chapter and tonight I...
2013-04-26
553 reads
Reblog: April 19 to April 25
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-26
1,036 reads
5 SQL Server White Papers Every DBA Should Read
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all...
2013-04-25
861 reads
Adding Data to Filestream with T-SQL
I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact...
2013-04-25
1,379 reads
Consultants – Why pay more?
As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the...
2013-04-25
1,422 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
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
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...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers