Latest 10 Posts
Databases are the longest-lived component
Abstract from Carpe Datum (Indexed 2010-09-09):
Most of you know that I write a technical article each week for the InformIT website - you can see a list of all my articles here. I’ve been writing for that site for – well, a really long time. I have articles all the way back to SQL Ser...(truncated)...
SQL Server 101: Back to Basics at SQL Bits
Abstract from Carpe Datum (Indexed 2010-09-07):
I’m traveling to the United Kingdom (York, England, to be specific) in September, joining Brent Ozar, Brad McGehee, Kevin Kline, Simon Sabin – and a host of other top-notch speakers. They will be covering deep technical topics ranging fro...(truncated)...
Database Copy Command & Handling Asynchronous Execution in T-SQL in SQL Azure
Abstract from TSQLNet Weblog - Cihangir Biyikoglu (Indexed 2010-09-01):
Database Copy T-SQL command in SQL Azure, provide the ability to create a identical copy of a database through a pure server side process. You can think of it as a command that backs up a database and restores it at the other end. You can refer to ge...(truncated)...
Slow query performance because inaccurate cardinality estimate when using anti-semi join following upgrade from SQL Server 2000
Abstract from PSS SQL Server Engineers (Indexed 2010-09-01):
We have a few customers who reported that some of their queries run slower following upgrade from SQL Server 2000 to SQL Sever 2005, 2008 and 2008 R2. Specifically, queries experiencing the issue have anti-semi joins in the query plan and the joi...(truncated)...
Optimizing CREATE SET in Cube Calculation Scripts
Abstract from MS SQL Server Development Customer Advisory Team (Indexed 2010-08-31):
Author: Thomas Kejser Reviewers: Peter Adshead, Nicholas Dritsas, Sanjay Nayyar, John Desch, Kevin Cox, Akshai Mirchandani, Anne Zorner In this blog we will describe an important optimization that you should apply to cubes that are processed ofte...(truncated)...
The New World of Work: Unique Tasks
Abstract from Carpe Datum (Indexed 2010-08-26):
In a previous post I mentioned that I’ve seen some Gartner Inc. studies, among others, that state that we’re in a “new world of work”. Since I’ve been working in technology for quite some time, and working around the wor...(truncated)...
SQL Server 2005: Execution Context
Abstract from Laurentiu Cristofors blog (Indexed 2010-08-25):
This post is based on an old presentation I gave several years back. A video of the presentation used to be available here, but today I couldn't get it to work, so I am attempting to make available most of the information from the presentation within...(truncated)...
Query performance and table variables
Abstract from PSS SQL Server Engineers (Indexed 2010-08-24):
Technorati Tags: Performance Frequently, we see our customers using table variables in their stored procedures and batches and experience performance problems. In general, these performance problems are introduced because of large numb...(truncated)...
Why use SQL Server 2008 R2 BPA? Case 1: Missing Updates..
Abstract from PSS SQL Server Engineers (Indexed 2010-08-24):
In June I introduced you to a new Best Practices Analyzer for SQL Server, SQL Server 2008 R2 BPA: http://blogs.msdn.com/b/psssql/archive/2...(truncated)... Ive seen some mixed reaction to this tool. But when I verbally talk to some about the type o...(truncated)...
A combination of crowdsourcing, people helping people, and the best technical community there is
Abstract from Carpe Datum (Indexed 2010-08-19):
I talk a lot about “giving back”. It’s a personal issue with me – I grew up quite poor, and from time to time someone would take notice that my mom and I didn’t have enough to eat, and they would help us out. I’ve ...(truncated)...
View All Posts...
Latest 10 Jobs
SQL Server DBA - OMNI-Source - Tampa, FL
(Indexed 2010-09-10):
SQL Server Integration Services (SSIS) and SQL Server... SQL Server DBA, SQL Server 2005/2008, SQL Server Management Studio, SQL Server Enterprise Manager, T-SQL... From iwantanewjob.ie - 10 Sep 2010 05:34:25 GMT - job details ...(truncated)...
MS SQL Server DBA - Wilson, CT
(Indexed 2010-09-10):
on the 2008 SQL Server platform. MS SQL 2005/2008... tools like: SQL Reporting Services (SSRS), SQL Server Information Services (SSIS), and SQL Server Analytic... From Monster - 10 Sep 2010 05:21:29 GMT - job details - View ...(truncated)...
SQL Server Database Developer - Xede Consulting Group INC - Troy, MI
(Indexed 2010-09-10):
databases (SQL Server) and 2+ years working on BI/DW projects 3+ years of solid experience as an ETL Developer and well-versed in Microsoft SQL Server ETL tool... From Monster - 10 Sep 2010 05:21:11 GMT - job details - View al...(truncated)...
Sr. SQL Server Database Developer / Data Analyst, TSQL - P Murphy & Associates, Inc. - Burbank, CA
(Indexed 2010-09-10):
Minimum 4 years SQL Server Database Development... skillsKeywords: SQLServer, SQL Server, TSQL, T-SQL, Transact SQL, TransactSQL, data hierarchy, taxonomy... From Monster - 10 Sep 2010 05:21:05 GMT - job details - View all Bur...(truncated)...
SQL Server Developer - TEKsystems - Boston, MA
(Indexed 2010-09-10):
is looking for a SQL Server Developer for a contract... will be responsible for designing and maintaining SQL Server databases, developing Business Intelligence... From Monster - 10 Sep 2010 05:21:58 GMT - job details - View a...(truncated)...
SQL SERVER Architect - Apex Systems - Huntsville, AL
(Indexed 2010-09-09):
workloads of our SQL based applications * Choose a model for SQL server scalability (single instance... with SQL Server 2008. Experience with SQL Server in... From Monster - 09 Sep 2010 04:24:21 GMT - job details - View all Hu...(truncated)...
Staff Internal Auditor - IT Ops, Oracle/SQL Server/MS Access - Volt Workforce Solutions - Richmond, VA
(Indexed 2010-09-09):
Server/MS AccessDescription:Staff Internal Auditor - ITIT Operations, Databases, Oracle/SQL Server/MS... technologies (Oracle, SQL Server, MS Access)Ability... From Monster - 09 Sep 2010 04:24:38 GMT - job details - View all R...(truncated)...
Sr. SQL Server DBA - TEKsystems - Minnetonka, MN
(Indexed 2010-09-09):
SQL Server 2005 experience- SQL Migration experience from SQL 2000 to SQL 2005 or SQL 2005 to SQL 2008... using SQL on Microsoft SQL Server 2005. - Database... From TEKSystems - 09 Sep 2010 03:41:14 GMT - job details - View al...(truncated)...
Lead Java Developer/HTML/Java script/Oracle/SQL Server - Technical Connections, Inc. - Hollywood, CA
(Indexed 2010-09-09):
2.4, JSP 2.0, JDBC, and SQL (HTTP, HTML, XML, Javascript, SSL, relational database experience (MySQL, SQL Server, Oracle), Spring or Hibernate platform... From iitjobs - 09 Sep 2010 02:54:58 GMT - job details - View all Holl...(truncated)...
Microsoft SQL Server Reporting Analyst - Tribune Company - Chicago, IL
(Indexed 2010-09-08):
development utilizing SQL Server Reporting Services... experience in SQL Server Reporting Services (SSRS) Significant Database experience (SQL Server, Stored... From Tribune Company - 08 Sep 2010 04:55:56 GMT - job details - V...(truncated)...