Practical advice, insight, and help for core SQL Server considerations such as high availability, disaster recovery, performance tuning, and other database administration tasks.
2/21/2012 by: Michael K. Campbell
In previous posts within this series, we’ve already looked at how you can’t really prevent corruption. Instead, in order to be able to better deal with corruption, you need to be able to detect it early. To that end, there are actually a number of ...
LEAP Think: Professional Development Guidance will explore ideas, advice, tips, tricks, and questions around the topics of leadership, entrepreneurism, and professional development. Many posts will be of interest to a wide range of careers and professions, but my goal will be to explore and present topics that are particularly relevant and interesting to technical professionals.
2/20/2012 by: Brian Moran
I’ve coached dozens of people through starting small businesses over the past decade. Everyone eventually has to decide ‘what entity should I pick? I’m not a CPA nor did I sleep in a Holiday Inn Express last night. So, please, run anything I say by ...
SQL Server Tools and Tips from Kevin Kline.
2/15/2012 by: Kevin Kline
Two quick notes from our friends at INETA: the Component Coding Challenge and INETA Community Champs. ...
Paul and Kimberly are a husband-and-wife team who own and run SQLskills.com
2/9/2012 by: Kimberly L. Tripp
Question: Partitioned tables were the new shiny feature in SQL Server 2005 – why are partitioned views even still available? Are there any benefits that they provide? Answer: In the first post (Partitioned Tables v. Partitioned Views–Why are they ...
Denny Cherry, a Microsoft MVP and Microsoft Certified Master, answers reader questions about the ins and out of SQL Server and the storage subsystem.
2/8/2012 by: Denny Cherry
There is a setting which is available within Cisco Fiber Channel switches that I ran across while configuring some new Cisco MDS switches that looked great for security. The setting is called "globalEnforcePriv" and the basic idea as I understand ...
Derek Comingore’s and Mark Kromer's Candid Look at SQL Server’s Business Intelligence Features.
1/16/2012 by: Mark Kromer
by Mark Kromer Late last year, Microsoft announced the availability of an updated beta or community technology preview (CTP) of SQL Server Reporting Services in the Cloud based on the Microsoft Azure platform: ...
News, Views, and Resources for DBAs.
11/18/2011 by: Megan Keller
The SQL Server 2012 Special Ops Tour could come to your city and you could be featured at an event. ...
SQL Server FAQs, Tips and Techniques
10/12/2011 by: Michael Otey
At the keynote in this year’s PASS 2011 conference Ted Kummert announced that SQL Server 2012 will include a new immersive data visualization technology named Power View. Formerly code named project Crescent, Power View is a data exploration and ...
T-SQL Tips and Logical Puzzles from Itzik Ben-Gan.
10/2/2011 by: Itzik Ben-Gan
Itzik describes new T-SQL scalar functions in SQL Server Denali CTP 3. ...
SQL Server FAQs, Tips and Techniques
8/2/2011 by: Michael Otey
There’s no doubt that availability is one of the most important if not the most important job for the database administrator. However, choosing the right options isn’t always easy because there’s a lot of different options and each is designed for a ...
News, Views, and Resources for Business Intelligence Pros.
3/21/2011 by: Blair Greenwood
Gartner released its 2011 Business Intelligence Platform Magic Quadrant that lists vendors that should be considered when selecting a business intelligence (BI) platform to develop reporting and analysis applications. ...
This blog covers the introductory SQL Server tasks that developers and DBAs are often afraid to ask about.
1/28/2011 by: Pinalkumar Dave
Pinal Dave explains the optimal value of the fill factor with detailed explanation. ...
News, Views, and Resources for SQL Server Developers.
8/3/2010 by: Sheila Molnar
LightSwitch is a developer tool based on .NET that “will be the easiest way to build business applications for the desktop and the cloud,” according to Microsoft. ...
News, Views, and Resources for T-SQL and PowerShell Scripters.
![]()
6/7/2010 by: Karen Bemowski
GridApp Clarity 6.5 database automation software uses a model-driven approach rather than scripts to automate processes and activities. ...