-
Five things you’re doing wrong with SQL Server
Are you hindering SQL Server without even knowing it? Check out the top mistakes DBAs often make with some quick fixes for better performance.
-
A first look at SQL Azure Database
Get a taste of Microsoft’s SQL Azure service for the cloud, and learn how it does (and doesn’t) compare to on-premise SQL Server functionality.
-
Fixing indexing issues for peak performance
Without the correct table indexes, SQL Server performance will quickly suffer. Here are a few tricks every DBA should know.
-
An introductory look at T-SQL system functions
Get the basics on working with various system functions in T-SQL to help assess the finer details of your data.
-
Digging deeper with T-SQL system functions
Learn how system functions can be used in T-SQL to view general session and system information along with other types of data in Microsoft SQL Server.
-
Three strategies for launching BI in your company
Small companies looking to get started with BI can ensure a successful implementation by following a few important tips.
-
SQL Server 2008 R2 says hello to Sysprep
A Windows staple for years, the Sysprep tool has finally made its way over to the SQL Server world with the release of R2.
-
Scripting database objects with SMO
The use of SQL Server Management Objects streamlines the process of scripting database objects, allowing DBAs and developers to customize code using basic SMO scripting know-how.
-
Dissecting the SELECT query syntax in T-SQL
With so many possible options and extensions, translating complex SELECT statements can be a challenge. DBAs can clear the air by breaking them down piece by piece.
-
Q&A: SQL Server BI meets the cloud
Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations.
-
SQL Server tool alleviates documentation headaches
Many database pros dread the hassle of SQL documentation. Fortunately, the right tool can speed up and simplify the process considerably.
-
SQL Server indexes: Weighing the performance impact
While the right indexes can boost readability, the wrong ones can really slow down write operations. DBAs need to strike the proper balance to ensure peak performance.
-
Applying subqueries to T-SQL statements: The basics
Subqueries in T-SQL give admins flexibility when it comes to analyzing the inner details of subsets of data. Learn how to apply subqueries with this comprehensive rundown.
-
Combining subqueries with operators in T-SQL
Using subqueries with different operators allows admins to collect even more information from T-SQL statement. Learn the basics of each and how to implement them here.
-
MDS alternatives for SQL Server master data management
With careful planning, DBAs can get similar functionality to Microsoft’s MDS feature -- without migrating to R2 -- by taking advantage of older SQL Server technologies.
-
Programming SMO applications: When, why and how
SQL Server Management Objects can be very helpful when used with (or even instead of) T-SQL, particularly when it comes to monitoring database backups and space utilization.
-
Is an Excel pivot table really business intelligence?
Although a pivot table is one component of Microsoft’s BI stack, it takes a lot more to create a full-fledged business intelligence solution.
-
Free tool helps ward off SQL injection attacks
DBAs can minimize the risk of injection attacks on their databases with this open source utility designed for Microsoft SQL Server and other systems.
-
Getting started with T-SQL mathematical functions
Mathematical functions in SQL Server 2008 can connect admins to system information that they may not know exists. Learn to apply these functions in this in-depth breakdown.
-
Apply algebraic and numeric functions
Expand even more on T-SQL mathematical functions with this breakdown of algebraic and numeric functions, including details on how they can be used to retrieve data.
-
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.
-
Top SQL Server management tools you should know about
Read this tip from Basit Farooq to learn which time-saving and job-improving SQL Server 2012 management tools you need to know about.