Latest 10 Posts
T-SQL: Do you use aliases?
Abstract from SSIS Junkie (Indexed 2008-07-04):
A pet peeve of mine is the lack of alias usage when using T-SQL. Im not sure why people dont bother using aliases Ive never asked- but I suspect its laziness. I can understand that but I want to speak up for the bastion of embattled SQL developers ou...(truncated)...
Converting from hex string to varbinary and vice versa
Abstract from SQL Server Engine Tips (Indexed 2008-07-03):
Converting hexadecimal values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005. The code samples below show how to perform the conversion(s): -- Convert hexstring value in a variable to varbinar...(truncated)...
SQL Server 2008 Improvements Practicals - PowerShell - Activity Monitor
Abstract from Carpe Datum (Indexed 2008-07-03):
I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 10:00am - "Panic Button": All of us get called from our cubes to come take a look at a performance problem. You've...(truncated)...
SQL Server, Windows Server 2008, and the Windows Firewall
Abstract from PSS SQL Server Engineers (Indexed 2008-07-03):
Sounds like a movie title. No, it is actually a topic you need to know about if you plan to install SQL Server 2005 or SQL Server 2008 on Windows Server 2008. Instead of me trying to explain the details I would rather you learn from the experts on t...(truncated)...
SQL Server 2008 Feature Pack RC0
Abstract from Carpe Datum (Indexed 2008-07-02):
The SQL Server 2008 Feature Pack for RC0 is now live - if you haven't downloaded this and played with it yet, shame on you! :) OK - just kidding - it's not like you don't have a day job. However, if you'll take a few moments and look this download ov...(truncated)...
Converting from Base64 to varbinary and vice versa
Abstract from SQL Server Engine Tips (Indexed 2008-07-01):
Converting Base64 values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005 onwards. The code samples below show how to perform the conversion: -- Convert Base64 value in a variable to varbinary: ...(truncated)...
XML Technology and Tools Survey
Abstract from Data (Indexed 2008-07-01):
The Data Programmability XML Tools team is conducting a survey focused on XML technology and tools usage over the coming weeks. The survey takes about 15 minutes to complete and wed appreciate it if you would take the time to respond to it. We plan...(truncated)...
Get Ready for SQL Server 2008
Abstract from PSS SQL Server Engineers (Indexed 2008-07-01):
Technorati Tags: SQL Server 2008,Extended Events Someone who contributes to this blog posted back in April that after the Europe PASS conference they would start in May creating some posts about SQL Server 2008 New Features especially ones related t...(truncated)...
All those temporary files (RSTempFiles)
Abstract from John Gallardos Weblog (Indexed 2008-06-30):
When you install Reporting Services, we create a few directories: LogFiles ReportManager ReportServer RSTempFiles Most of these are fairly self explanatory. LogFiles... well we put our log files in there. ReportManager contains the Report Manager ...(truncated)...
SQL Server 2008 Improvements Practicals - PowerShell - Run a "Panic" Backup
Abstract from Carpe Datum (Indexed 2008-06-30):
I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 10:00am - "Panic Button": Now that I've found there are a few databases that haven't been backed up, I want to run...(truncated)...
View All Posts...
Latest 10 Jobs
SQL Server 2000/2005 Developer - Kforce - Morristown, NJ
(Indexed 2008-07-05):
and support multiple SQL Server Databases, data feeds... Proven experience in a Microsoft SQL Server environment with strong SQL, Stored Procedures, Triggers, DTS... $65,000 - $75,000 a year (From Kforce)
Senior SQL Server Developer/DBA - Kforce - Parsippany, NJ
(Indexed 2008-07-05):
MS SQL Server 2000, 1-2+ year of MS SQL Server 2005... SQL Server 2000/2005, Enterprise Manager, Query Analyze, Reporting Services, Analysis Server, SQL Server... $90,000 - $100,000 a year (From Kforce)
C#, VB.Net, ASP.Net, SQL Server Developer/Analyst - Kforce - Parsippany, NJ
(Indexed 2008-07-05):
ASP.Net, XML, XSLT, SQL Server 2000/2005, and various... 3.0, Microsoft COM+/DCOM, Microsoft IIS 5.0, MS SQL server 2000/2005, DHTML, XML, JavaScript, 3rd Party... $80,000 - $95,000 a year (From Kforce)
Production DBA SQL Server - ingenio - San Francisco, CA
(Indexed 2008-07-05):
strategies with SQL Server 2005 in a 24x7 production... distributed data issuesRequirements:* 3 to 5 Years SQL Server production DBA experience* Experience with... (From Beyond.com)
SQL Server DBA - TMC Software - San Francisco, CA
(Indexed 2008-07-05):
Job Title: SQL Server DBALocation: San Francisco, CAJob Description: Skills: DBA, SQL Server Term... G 5 years of SQL Server DBA experienceTechnical... (From Beyond.com)
Applications Development/Applications Support Engineer (SQL Server) - Plus Group - Atlanta, GA
(Indexed 2008-07-04):
the data into a SQL Server data warehouse and then... the following required skill: SQL Server SQL Server Reporting Services SQL Server Integration Services... (From Dice)
SQL Server Developer / DBA --- Contract to Hire - Empower Professionals - Cedar Rapids, IA
(Indexed 2008-07-04):
Salary (W2) Availability SQL Server Developer / DBA Job Description: Senior SQL Server Developer/DBA will... SQL Server 2000 and Enterprise Manager; SQL Server... (From Dice)
Sql Server Database Analyst - Technisource - Littleton, CO
(Indexed 2008-07-04):
test and implement SQL Server applications (and web... a SQL Server DBA and database development and optimization. 4+ years experience with developing SQL Server... $80,000 a year (From Dice)
Implementation Manager - SQL Server Project Management - CyberCoders - Spring, TX
(Indexed 2008-07-04):
MS SQL, database management, MS Access, - SQL Server... Manager - SQL Software implementations Are you a Project manager with SQL server and MS Reporting skills... (From Dice)
SQL Server Database Administrator - CGI - Lancaster, SC
(Indexed 2008-07-03):
to SQL server 2005. Required Skills: 3 Yrs. of SQL... and troubleshooting SQL Server 2000 and 2005 3 Yrs. experience with SQL Server and T-SQL in constructing... (From Dice)
Reporter Network