Latest 10 Posts
PowerShell and SQL Server: Script all Tables
Abstract from Carpe Datum (Indexed 2009-07-02):
This is a script that I found/put together/re-arranged that will script out all of the tables from a database - in this case, Adventureworks2008. You need to change the BWOODY1 part to the name of your server, and the SQL2K8 part to your Instance nam...(truncated)...
Building a robust setup experience with Reporting Services
Abstract from Musings on Reporting Services and Notification Services (Indexed 2009-07-02):
This post is intended for ISVs or Product Development organizations who are planning to integrate Reporting Services into their product. Over the years I have seen a number of products do this and some get it right and some encounter issu...(truncated)...
SQL Server Best Practices: Auto-Shrink Should Be Off
Abstract from Carpe Datum (Indexed 2009-07-01):
SQL Server is one of the easiest databases to maintain because of all of the automatic settings it has, but as I mentioned with Auto-Close, some of them should be left off. The Auto-Shrink setting is another. That might surprise a few people. You mi...(truncated)...
When in doubt, Reboot!
Abstract from PSS SQL Server Engineers (Indexed 2009-07-01):
I tend to get quite a bit of Kerberos related cases. These are related across the box, from the Engine, to Reporting Services to just straight connectivity with custom applications. I had one given to me yesterday because the engineer had...(truncated)...
Interesting issue with Filtered indexes.
Abstract from Microsoft SQL ISV Program Management Team (Indexed 2009-06-29):
Recently, an ISV I work with ran into an interesting problem with Filtered Indexes.The application does all SQL INSERT, DELETE, and UPDATE operations using individual stored procedures. To improve performance, they decided to create a Filtered Index ...(truncated)...
Grid Painting and Database Projects
Abstract from Carpe Datum (Indexed 2009-06-29):
I'm not very good at drawing. My drawings of people and objects with depth usually looks like what your 5th grader does, but not the talented 5th grader. But I found a trick that helps me draw not only depth, but complex things as well. It involves ...(truncated)...
Interesting issue with Filtered indexes.
Abstract from SQL Programmability & API Development Team Blog (Indexed 2009-06-29):
Recently, an ISV I work with ran into an interesting problem with Filtered Indexes.The application does all SQL INSERT, DELETE, and UPDATE operations using individual stored procedures. To improve performance, they decided to create a Filtered Index ...(truncated)...
Azure worker role development tips
Abstract from SSIS Junkie (Indexed 2009-06-29):
Just lately Ive been doing a lot of messing around with Windows Azure the main focus of which has been exploring Azure storage (tables, queues, blobs) and how those things can be manipulated from Azure worker roles. One output from that messing aroun...(truncated)...
Use PowerShell to Backup All User Databases
Abstract from Carpe Datum (Indexed 2009-06-25):
This script will back up all user databases - you need to change the BWOODY1SQL2K8 part to your serverinstance name, and of course, you should only run this on a test system until you completely understand it. Unfortunately, the SQL Server PowerShel...(truncated)...
Maximum Row Size and Query Hints
Abstract from Craig Freedmans WebLog (Indexed 2009-06-24):
In my last post (yes, that was two months ago), I gave an example of how a query hint could cause a query to fail. In this post, I'll give another example of how query hints can cause problems. As with my last post, this post was inspired by a ques...(truncated)...
View All Posts...
Latest 10 Jobs
Junior SQL Server 2008 DBA Needed Immediately! - Robert Half Technology - Houston, TX
(Indexed 2009-07-03):
--Description-- Classification: Contract to Full TimeHung Lee Account Executive1300 Post Oak Blvd, Suite 300Houston, TX 77056office 713-993-1888... From CareerBuilder - save job, email, more...
Business Intelligence Applications Specialist/SQL Server Expert - Volt Workforce Solutions - Redmond, WA
(Indexed 2009-07-03):
Specialist/SQL Server Expert... Business Intelligence Applications Specialist/SQL Server Expert... SQL Server Expert Qualifications: SQL Server... From Monster - save job, email, more...
SQL Server DBA - COMSYS - New York, NY
(Indexed 2009-07-03):
Information SQL Server DBA Major international financial firm is currently seeking a SQL Server DBA... data-feeds,Expert on SQL 2000 and SQL 2005.Please... From Monster - save job, email, more...
SQL DBA - SQL Server Database Admin - SQL Engineer / DBA - CyberCoders - Granada Hills, CA
(Indexed 2009-07-02):
SQL DBA - SQL Server Database Admin - SQL Engineer / DBA near Granada Hills, CA This job is open as of 7/1... for this job? Search other SQL DBA jobs! Are you an... $65,000 - $80,000 a year From HotJobs - save job, email, more...
SQL Server DBA - Technisource - Iowa, IA
(Indexed 2009-07-02):
SQL Server 2000,2005, and 2008 Hands on experience upgrading from MS SQL Server 2000 to MS SQL Server 2005... Work: SQL Server 2008 Certification SQL Server 2005... From JobServe USA - save job, email, more...
Senior Technical Architect - .NET, SQL Server - PERM - DataMasters - North Carolina
(Indexed 2009-07-02):
Permanent Position - Technical Architect - .NET, SQL Server Major Job Responsibilities: Leads development of complex customer-facing software applications... From JobServe USA - save job, email, more...
Developer w/SQL Server, XML, Visual Studio; Healthcare experience - iTech Solutions, Inc. - Phoenix, AZ
(Indexed 2009-07-02):
systems analysis and design; systems development life cycle methodology, and client server development tools is critical. A minimum of 2 years of applications... From iTech Solutions - save job, email, more...
Backend SQL Server Expert - Software Development Engineer - Volt Workforce Solutions - Redmond, WA
(Indexed 2009-07-02):
LLC... Backend SQL Server Expert - Software... Looking for a backend SQL Server expert who specializes in SQL backend work. SQL Server 2005/2008 - must... From Monster - save job, email, more...
SQL Server Developer - Consultant/Senior Consultant - FTI Consulting, Inc. - Pittsburgh, PA
(Indexed 2009-06-30):
T-SQL. Ability performance tune poorly running T-SQL... relevant experience with MS SQL Server 2000/2005. 3+ years experience designing and writing complex T-SQL... From CareerBuilder - save job, email, more...
Ms Sql Server Database Administrator * - SHARF, WOODWARD & ASSOCIATES - Dallas, TX
(Indexed 2009-06-30):
Ms Sql Server Database Administrator... Job Description: MS SQL Server Database Administrator... performance tuning, server hardware, logging... From HotJobs - save job, email, more...
Reporter Network