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.
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 the not-so-proper...
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 professionals read 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 with especially...
Learn how you can replace a scalar-valued user-defined functions (UDFs) call with actual code to greatly improve SQL Server performance....
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....
SQL Server logs can make troubleshooting problems simpler—if you know where to look. Here are 5 SQL Server 2005 log files that might come in handy....
Database encryption can protect your data from internal and external attacks. When choosing a solution, consider who you are protecting data for and who you are protecting it from, along with any...
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. ...
Catch up on the latest with Michael Otey - SQL Server tips, techniques and FAQs
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.
Learn how you can replace a scalar-valued user-defined functions (UDFs) call with actual code to greatly improve SQL Server performance.
SQL Server Data Tools in SQL Server 2012 offers more than declarative schema-based database design and T-SQL debugging--here's what to look for in this super tool.
The answer to the question here will depend greatly on what storage platforms you have available to you. Assuming that you have some sort of storage array which supports ...
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 ...
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