Learning Powershell
I’ve been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my blog you might be aware...
2010-06-23
1,686 reads
The Scary DBA
Sarasota SQL Server Users Group
Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...
2010-06-15
702 reads
Virtualizing Servers in Production
The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...
2010-06-15
861 reads
Maps in Reports!
I’ve been playing with SQL Server 2008 R2 for quite a while in the CTP’s and what not. But, I hadn’t made...
2010-06-14
1,210 reads
I’m a Pain
Or maybe I’m misreading that I’m supposed to be helping to alleviate pain. Either way, next Thursday, June 17, I’ll be...
2010-06-10
549 reads
PASS 2010 Submissions
Since all the cool kids seem to be posting the sessions that they submitted to the PASS Summit, nerd that...
2010-06-09
803 reads
Buy vs. Build
It’s the classic question faced by everyone in Information Services. I know how to do this and I could build...
2010-05-28
1,595 reads
Slick New Software
I’m lazy. And frankly, I’m not ashamed to admit it. When a software comes along that can do the work...
2010-05-24
1,276 reads
Recompiles and Constant Learning
When faced with a procedure that looks like this:
CREATE PROCEDURE dbo.TestProc (@TestValue INT)
AS
BEGIN
IF @TestValue = 1
BEGIN
SELECT *
FROM Sales.SalesOrderHeader AS soh
JOIN Sales.SalesOrderDetail...
2010-05-11
766 reads
PASS Summit, Kilt Wednesday
Last year at the PASS Summit we held a silly little event called Kilt Wednesday. Only three people took part,...
2010-04-27
1,399 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Simple Junction table design question
I have a disagreement with the programming team on an app that I designed....
Sql query to check the status change for an item
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
Migration of on-premises SQL Server to an AWS PostgreSQL database
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers