New Year Aspirations – Christian Bolton – Author
As a former mentor Christian is used to me asking him all sorts of random questions, but this time it’s...
2013-01-29
1,536 reads
Clustering Concepts for the Common Man
SQL Server clusters are widely used, and widely misunderstood, which makes people like our good friend (and clustering MVP) Allan...
2013-01-29
1,447 reads
SSRS 101 – Creating a SQL Server Reporting Services Project
This is the second installment in this series of SQL Server Reporting Services 2012 Beginner posts. You can read the...
2013-02-07 (first published: 2013-01-29)
4,856 reads
How to Remove (Undo) Table Partitioning
I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but...
2013-02-04 (first published: 2013-01-29)
8,809 reads
Are You A Technical Expert or Manager?
Expert or Manager? Why not both.
Are you a Technical Expert or a Manager? You certainly cannot be both.
At least that’s...
2013-01-29
1,003 reads
SQL Server Silent unattended installation using configuration file
1) Open Installation Wizard
Open Installation Wizard
2) Select Feature You want to install
Select Feature You want to install
3) Provide installation configuration
Provide...
2013-01-29
6,505 reads
Day 23 of 31 Days of Disaster Recovery: Restoring Differential Backups With New Files
It’s day 23 of my 31 Days of Disaster Recovery series, and today’s blog post is inspired from an email...
2013-01-29
1,587 reads
SQL Server
What is SQL Server?Microsoft SQL Server is Relational database management system (RDBMS) developed and owned by Microsoft. It is a software...
2013-01-28
438 reads
Granting Permission to Grant Permissions
I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a...
2013-02-08 (first published: 2013-01-28)
2,574 reads
"Auto update statistics" option on tempdb
"Auto update statistics" option is enabled by default on tempdb, if it is disabled, you may get trouble in some...
2013-01-28
2,939 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
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
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...
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