SQL Saturday - Columbia
I've talked about trying to do a SQL Saturday event in Columbia, SC, for the last couple of years, ever...
2010-03-26
666 reads
Databases – Infrastructure – Security
Learning About Microsoft Certified Master: SQL Server
Among the Microsoft certifications, the Microsoft Certified Master is the apex of all of them except maybe the Microsoft Certified...
2010-03-26
1,673 reads
Have a Question? Use the Forums
I try to keep a pretty tight lid on the comments to the blog because there's a lot of SPAM...
2010-03-25
524 reads
Avoiding Plagiarism
Having gone to an academic magnet school, I have quite a few friends who are teaching at the university level...
2010-03-24
1,885 reads
Don't Throw Something New In At Production Deployment
This post comes from a conversation I had with a developer last week as well as my experiences over the...
2010-03-22
1,802 reads
When It "Has" to Use SA...
As an infrastructure and security architect, I cringe any time any one mentions the following:
Domain AdminrootsaThose accounts can do anything...
2010-03-19
644 reads
New Goal: Security Presentation for End Users on Social Media
Cross-posted from the Goal Keeping DBA:
In recent days I’ve seen folks jump on Facebook groups and become fans of pages...
2010-03-18
691 reads
Working for/with High Caliber Folks
Within a couple of days of each other, both Andy Leonard (@AndyLeonard) and Paul Randal (@PaulRandal) tweeted about possible job opportunities which would...
2010-03-12
1,851 reads
Upgraded to Model
That's right, folks, I'm now a model. Or at least, a model DB. Tom LaRock released his most recent rankings and...
2010-03-10
565 reads
PASS Summit to Stay in Seattle
PASS has released the survey results as well as its decision about where to hold future Summit events. The decision...
2010-03-10
1,979 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
SQL Monitoring tools
our client wants to implement Third Party SQL Monitoring tool to monitor SQL server...
PowerQuery.... don't meet SSIS
I have a powerQuery that reads and transforms a table in a PDF. Works...
Count of Total Appointments within 30 days of each Appointment Date
Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2)...