The Smart Guide to Building World-Class Applications
Delivering practical database advice for DBAs, developers, and BI analysts
Configuring authentication in SSRS isn't always a straightforward task because it occurs at multiple points and involves multiple technologies. This guide will show you the basics so that you can get started.
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...
No... Oh you wanted more information than that? OK Here goes......
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...
Learn which Microsoft and third-party products will have the tools you need to stay on top of SQL Server development, administration, and business intelligence (BI) challenges in the coming year....
These five tips help you avoid a few frustrations that might arise when developing SQL Server Integration Services (SSIS) packages so you keep your development efforts moving forward....
Configuring authentication in SSRS isn't always a straightforward task because it occurs at multiple points and involves multiple technologies. This guide will show you the basics so you can get...
Learn how you can replace a scalar-valued user-defined functions (UDFs) call with actual code to greatly improve SQL Server performance....
An awful lot of rain half way around the world is keeping me from getting hard drives delivered to a data center in New Jersey. ...
Question: I came across a situation where a transaction log backup failed because of corruption in the transaction log. One of my colleagues put the database offline and then online and problem went...
Catch up on the latest with Michael Otey - SQL Server tips, techniques and FAQs
Question: Several times in the last year I’ve been forced to run the repair option of CHECKDB because of corruption affecting a database and backups being unavailable. In one case ...
When it all comes down to it there are really only two main things that DBAs need to worry about: making data available to the proper people, and making sure it’s inaccessible to ...
Brian Moran highlights the SQL Server 2012 Virtual Launch Event and explores how Apple's iBooks 2 electronic textbook publishing platform will change the way SQL Server ...
Itzik wraps up his discussion of SQL Server 2012's window functions by focusing on optimization. He provides indexing guidelines for optimal performance, and he describes cases ...
These five tips help you avoid a few frustrations that might arise when developing SQL Server Integration Services (SSIS) packages so you keep your development efforts moving ...
Configuring authentication in SSRS isn't always a straightforward task because it occurs at multiple points and involves multiple technologies. This guide will show you the basics ...
Loading new data and purging old data from a table can take a lot of time if a large amount of data is involved. Here's an elegant partition solution that loads and purges data ...
An awful lot of rain half way around the world is keeping me from getting hard drives delivered to a data center in New Jersey.
advertisement
DATES: 3/26/2012-3/29/2012
LOCATION: Las Vegas, MGM Grand
EVENT TYPE: Conferences & Workshops
DESCRIPTION:
SQL Server Connections and Microsoft are teaming up to launch the next version of SQL Server at MGM Grand in Las Vegas, NV. Join us!
More Events