-
SQL troubleshooting with Pssdiag and Sqldiag Manager
What’s the most important part of SQL troubleshooting? Pssdiag and Sqldiag manager, says SQL Server professional Serdar Yegulalp. Find out what makes Pssdiag and Sqldiag so important.
-
More new T-SQL Commands in SQL Server 2012
In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more.
-
Three new T-SQL commands to make your life easier
Each release of SQL Server brings changes to Transact SQL. In this tip, expert Serdar Yegulalp gives a walkthrough of tweaks like WITH RESULT SETS for renaming columns and THROW for catching errors.
-
Configuring SSRS the easy way
Demystify the SQL Server Reporting Services (SSRS) configuration process. Get an overview of this tool and guidelines for how to set up each screen in SSRS from industry professional Roman Rehak.
-
SQL Server 2012: The easy way to upgrade
You probably think you’re ready to upgrade to the new release, but you might not be as prepared as you think. Before you upgrade, there are some tools to become familiar with, says Bob Sheldon.
-
ODBC databases replacing OLE DB? Say what?
After years of telling SQL Server users to avoid ODBC in favor of OLE DB, Microsoft has suddenly reversed its position and advised going back to ODBC. Why? And what should you do about it?
-
Use PowerShell capabilities to improve administration
With SQL Server 2012, Microsoft has gone whole-hog SQL Server, with great PowerShell capabilities. But what’s the best way for a DBA to manage them? Read this tip from Don Jones to find out.
-
Pros and cons of SQL Server 2012
Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and “the unknown” might keep you away for now.
-
Split root table with T-SQL in SQL Azure Federations
SQL Azure Federations can help manage massive amounts of data, says Roger Jennings. In Part 2 of this two-part series, read on for instructions on splitting the federation root table.
-
No-risk SQL Server upgrade for SSRS no problem
Worried about mishaps during your next SQL Server upgrade? What if you could perform an upgrade that is virtually risk free? It is possible, database architect Roman Rehak writes.
-
Manage, query SQL Azure Federations using T-SQL
Can SQL Azure help you manage “big data?” SQL Azure Federations enhances traditional partitioning, says Roger Jennings. Part 1 of this two-part series looks at using T-SQL to make federated tables.
-
Microsoft SQL Server: Cheaper, simpler than Oracle DB
SQL Server expert Denny Cherry argues that SQL Server is better than Oracle Database because it is cheaper, simpler and has a better supportive community.
-
SQL Server virtualization: Not always a good idea
SQL Server virtualization may seem like a magic bullet, but there a few scenarios that might cause businesses to reconsider.
-
Cost-benefit’s the issue with backup compression
Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider.
-
Speed up execution times in Microsoft SQL Azure
Compare the time cost of database calls to SQL Azure versus calls to a local server and get recommendations for improving the speed of database calls to SQL Azure.
-
Is cloud-based business intelligence a safe bet?
Cloud-based business intelligence has its attractions, especially for SMBs having a hard time supporting any BI in-house. But don’t forget to ask some crucial questions.
-
Microsoft SQL Server 2012 pricing packed with changes
SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing.
-
Microsoft tailors BI capabilities for users, IT in SQL
Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management.
-
Microsoft BI casts wide net with new tools and toys
The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services.
-
Five things in SQL Server not in SQL Azure
With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server.
-
Database index design and optimization: Some guidelines
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.
-
SQL Server meets database application security
Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.
-
xVelocity Columnstore Indexes in SQL Server 2012
Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.
-
Useful SQL Server 2012 features to become familiar with
SQL Server expert Basit Farooq shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more.