-
Scenarios abound for SQL Server Master Data Services
SQL Server Master Data Services, Microsoft’s master data management service, can be put to a number of different uses in businesses concerned about data quality and consistency.
-
Plan ahead for a smooth SQL Server migration
The thought of a SQL Server migration makes many organizations nervous, but they don’t have to be, writes consultant Don Jones. Get tips on making the switch simple.
-
Keep data square with SQL Azure Data Sync
Learn how to use SQL Azure Data Sync to keep SQL Server and SQL Azure databases across dispersed geographic locations using a simple point-and-click interface.
-
Map data flow from PowerPivot to Excel, SharePoint
Microsoft PowerPivot, when used with Excel and SharePoint, lets business users manipulate data in Excel workbooks. But how do PowerPivot components fit into those environments?
-
SQL Server consolidation good; not checking metrics bad
SQL Server consolidation could save your company big money, writes expert Denny Cherry, but first you’ll need to examine metrics like concurrent connections, buffer pool size and drive space.
-
Database capacity planning: A head-on approach
IT administrators often don’t give a lot of thought to SQL Server database capacity planning -- until the database fills up. But managing database capacity now can help cure headaches later.
-
Techniques for scaling out SQL Server
Scaling SQL Server out is not easy; that’s why most businesses choose to scale up their databases instead. But some applications give you no choice: You’ve got to look at options for scaling out.
-
Microsoft retools SQL Server stored procedures
Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release.
-
Managing SQL Azure isn’t no-fuss, but it’s close
It takes work to manage a SQL Azure database, but not much, according to consultant Don Jones. Find out what tasks DBAs need to perform to keep Microsoft’s cloud service running smoothly.
-
Three easy ways to improve SQL Server performance
A sluggish database does no one any good. Consultant Don Jones offers tips to improve SQL Server performance.
-
Don’t get stuck with sluggish BI system performance
Poor BI system performance can be a real problem, but that doesn’t mean it should get you down, consultant Don Jones says. Find out how to give your system a needed boost.
-
Microsoft SSIS basics: Tying it all together
SQL Server Integration Services (SSIS) is designed to make data integration between disparate systems easy. SQL Server expert Don Jones covers the Microsoft SSIS basics.
-
For SMBs, data journey starts with BI integration
The first step in any business intelligence (BI) implementation, according to consultant Don Jones is BI integration -- getting both BI and business systems in sync.
-
SQL Server-Hadoop highway ventures into new territory
Microsoft’s SQL Server-Hadoop connectors bridge the structured, relational database world with the unstructured universe of big data. For DBAs, there’s a whole lot to get used to.
-
Scalability, capacity skew colossal in SQL Server 2012
SQL Server 2012 has scalability and capacity features targeting applications that work with massive data sets. Learn about column-store indexes, 15,000 partitions and more.
-
Three monthly checks for managing database capacity
Managing database capacity is something DBAs can’t take lightly. Find out what to look at to keep capacity at the proper levels.
-
New to SQL Server PDW? First, tinker with client tools
Stepping into the SQL Server PDW environment means learning a whole new set of client tools. Learn about each as you take on Microsoft’s Parallel Data Warehouse.
-
For your next SQL Server upgrade, rely on replication
SQL Server upgrades have a reputation for causing hassles. Learn how SQL Server replication can simplify the process of migrating from old version to new.
-
With SQL Server data warehouse tables, think big
Along with the popularity of SQL Server data warehouses come huge data warehouse tables. To handle them, database administrators may need to tweak the traditional approach.
-
Fine-tune applications for fleet SQL Server performance
Databases with large numbers -- read millions -- of rows require efficient applications. Improve SQL Server performance by following a few tips and guidelines.
-
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.