Are You on Twitter?
Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time....
Exceptional PowerShell DBA Pt2 - The Morning Checklist
Laerte Junior takes us further into the world of an Exceptional PowerShell DBA, showing us how he uses PowerShell 2.0 to take all the headaches out of even more of his daily checklist. What could be better than having your morning checklist run itself?
SQL Saturday #30 - Richmond
Another great one day training event in Richmond, VA on Jan 30. Be sure to attend.
TSQL Challenge 22 - Filling balls into boxes based on rules and preferences
We have got some boxes and balls. Our job is to put balls into those boxes. But, wait a second! The balls should be filled into the boxes based on some rules and preferences configured by the user. Here are the rules.
DevWeek 2010 is Coming Up
The time has come again for the UK’s biggest conference for .NET developers and SQL Server professionals. Read the press release about this years DevWeek.
Get Your ANSI_NULLs Settings Consistent
William Talada brings us a short article to help you check your ANSI NULL settings and gives you a few reasons why you might want to make them consistent.
SQL Server Consolidation : how to decide on the right approach
The PASS DBA VC hosts this session today that will focus on helping to choose between using a virtualization, instance, or database consolidation option. We will highlight a few of the key areas to consider as well as some of the important differentiators to keep in mind. We will provide a decision tree to help guide administrators through the process of selecting a consolidation option.
The Dying Administrator
Is the SAN administrator dying out as a job? Steve Jones comments on an article that suggests it might be.
Celko's SQL Stumper: The Class Scheduling Problem
What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!
SQL Saturday #34 - Boston
Coming on Jan 30, to the Boston area, be sure to attend this SQL Saturday if you are nearby.
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
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....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers