Paul and Kimberly are a husband-and-wife team who own and run SQLskills.com
2/2/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: This is actually a question I get at almost every event at which I speak. ...
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/1/2012 by: Denny Cherry
No... Oh you wanted more information than that? OK Here goes... ...
Practical advice, insight, and help for core SQL Server considerations such as high availability, disaster recovery, performance tuning, and other database administration tasks.
1/30/2012 by: Michael K. Campbell
In my last post I provided an overview of what SQL Server database corruption is – and how it’s almost always caused by problems at the IO subsystem (or disk) level. However, while it’s all fine and well to talk about things in such a theoretical ...
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: ...
SQL Server Tools and Tips from Kevin Kline.
1/9/2012 by: Kevin Kline
Check out the latest update for SQL Server FineBuild, a tool which speeds the installation and configuration of SQL Server and associated tools and programs. ...
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.
11/28/2011 by: Brian Moran
I read a lot. Ideas make me think. Considering and dissecting ideas from other people shape the way I think. The process refines my ideas and makes me a better person in countless ways. But the process of integrating ideas from other people into my ...
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. ...