Backup/Restore vs Detach & Attach
You want to move a database from one server to another. There are two options to do that.
1) Detach/Attach: To...
2011-10-04
1,019 reads
Attend the PASS Summit from Home, 2011 edition
Hidy-ho there, neighbors! This is an update of last year’s Attend the PASS Summit from Home blog. I’ll be updating this...
2011-10-03
1,544 reads
SQL Server – Marking a stored procedure as system object
Marking a stored procedure as system object allows to run the procedure in a user database context. There are two...
2011-10-03
2,727 reads
SQL Bits 9
SQL Bits was great
It’s been two years or more that I’ve been invited to SQL Bits. Not by email, but...
2011-10-03
1,268 reads
Using Configuration Tables in SSIS 2008/2005
SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations...
2011-10-03
1,273 reads
A "New Guy" Joins Our Team
It's a great day for me and Moulding and Millwork (the company I work for). A few weeks back, I let you all know that I'd been given the...
2011-10-03
9 reads
A "New Guy" Joins Our Team
It's a great day for me and Moulding and Millwork (the company I work for). A few weeks back, I let you all know that I'd been given the...
2011-10-03
9 reads
October Monthly SQL Server Checklist
It’s the first Monday of the October and it’s time to do a monthly checkup. If you are like me,...
2011-10-03
585 reads
SQL Authentication – Forcing Password Changes
When you create a SQL Server login (with SQL authentication), you have the option of enforcing password policies from Windows...
2011-10-03
6,225 reads
Want to browse the web faster?
In our day-to-day activities, browsing the web is one of the most important aspects of our job. Whether researching for...
2011-10-03
817 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers