SQL Saturday Baton Rouge – Recap
After a long weekend of travel and speaking, I’m finally able to put my feet up and get a little...
2009-08-03
985 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
Why Make Up Test Data? Snag Some Government Data
… and by government data, I mean the mountain of data recently made available by the G-Men on Data.gov. This site...
2009-07-28
1,339 reads
Social Networking in the SQL Server Community
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others in the SQL community. Some of those who don’t use Facebook and Twitter (among others) have expressed skepticism of the real value of social networking. Does it work? Does it provide any value beyond entertainment? Can it actually help your career? I believe the answer to all of these queries is Yes.
2009-07-24
1,698 reads
Social Networking in the SQL Server Community
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others...
2009-07-20
1,852 reads
SQL Saturday Dallas
We are in the early stages of planning a SQL Saturday event in the Dallas area for January or February...
2009-07-19
1,072 reads
Being The Best vs. Being Affordable
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though the story was specific to database professionals, the same principles apply to almost any hiring situation. The moral of Brent’s story...
2009-07-16
1,541 reads
Being The Best vs. Being Affordable
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though...
2009-07-13
600 reads
The Netbook
I like my main laptop. It’s big and wide and bright, with lots of power and all of the bells...
2009-07-11
1,389 reads
Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your inserts and a no-deletion policy, you find that there are missing values in what should be an unbroken sequence of numbers. The problem could be partially related to transaction rollbacks.
2009-07-09
4,586 reads
Presenting at SQL Saturday Baton Rouge
I'll be presenting two sessions at the SQL Saturday event in Baton Rouge on August 1. I'll be presenting a...
2009-07-06
477 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
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...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
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-...
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