2012-01-11
2,209 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Referencing Remote Data
Synonyms were added to SQL Server to make the references to remote data easier. However Steve Jones doesn't use them, do you? Are there benefits?
2012-01-10
152 reads
T-SQL Tuesday #26 – Second Changes with Date/Time
I missed the very first T-SQL Tuesday, so when this month’s topic of second chances came up, I decided to...
2012-01-10
1,399 reads
2012-01-10
2,476 reads
Capacity planning for new hardware
I get asked this question a lot: When getting a new application and database, what kind of hardware do I...
2012-01-09
1,630 reads
DBAs in Denver
I have a friend looking for a production DBA in Denver, so if you’re interested, email me at SQLServerCentral.
They need...
2012-01-09
773 reads
2012-01-09
2,291 reads
Creating Strong Passwords
I was writing a presentation recently on encryption and one of the important things to show in the presentation is...
2012-01-06
1,065 reads
Read-only Data
Today's poll looks at read only data and how you handle the backup and recovery of this data.
2012-01-06
136 reads
SQL Server 2012 Licensing VMs without SA
I ran across a blog talking about Microsoft licensing, and found it very interesting. I learned a few things, and...
2012-01-06
1,996 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers