Thoughts on Virtualization
I get a lot of questions about virtualization and really have few answers. At a high level it's not hard...
2008-05-25
1,676 reads
Blog Posts
Reminder: Midlands PASS Chapter Meeting with Brian Knight
Tuesday, May 27, 2008
Speaker: SQL Server MVP Brian Knight
The Midlands PASS chapter will hold a special meeting on...
2008-05-23
1,727 reads
SQL Saturday in Orlando
The dates for Microsoft's TechEd 2008 are fast approaching here in North America. Sandwiched between the two weeks of this year's...
2008-05-23
1,946 reads
Visiting Birmingham SQL Group in June
I'll be doing a presentation for the Steel City SQL Group on June 17 and then on June 18th I'm doing...
2008-05-23
1,372 reads
Hard Core Object Oriented Programming Guidelines
I read Andrew Binstock occassionally in SD Times and in the most recent issue he posted a list of guidelines...
2008-05-21
1,693 reads
Pop Quiz - What's the Max Number of Resultsets Supported by Management Studio?
Ran across this strange occurence while doing some testing. To duplicate the results (the actual code was a little more...
2008-05-20
1,478 reads
Review of How to Cheat at Securing SQL Server 2005
SQL Server MVP Frank Kalis has posted a short review on How to Cheat at Securing SQL Server 2005, a...
2008-05-20
1,896 reads
Answers To DBA Interview Questions
Here are your answers to the questions from last week You should get some variation of what I have given...
2008-05-19
2,730 reads
Answers To SSIS Interview Questions
This is just a starting point for you to prepare for your interview so make sure not to limit yourself...
2008-05-19
4,057 reads
Collation Issues
This is really interesting to me:
CREATE TABLE #TEMP (name varchar(80))
INSERT INTO #TEMP values ('Malteser Schloßschule')
INSERT INTO #TEMP values ('Malteser...
2008-05-19
714 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
Legacy Technology Services: Enhancing Business Efficiency with Exceptional
In the modern business landscape, success hinges not only on access to cutting-edge equipment...
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)...
Reporting Services in Managed Instance
Hi , one of my on-premises servers one server is having databases and one...