-
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.
-
Three ways to scale a SQL Server BI system
Want more from your SQL Server business intelligence system? Expert Don Jones has some answers for you: Scale up, scale out or buy new and big.
-
Before migrating from an open source RDBMS, have a plan
Migrating from an open source RDBMS to free versions of database systems like SQL Server or Oracle might be tempting. Here are a few things you need to first consider.
-
Microsoft MDS plucks DBAs from the data fracas
Microsoft MDS, or Master Data Services, aims to dissolve workplace arguments about whose data is correct, and it puts DBAs at a safe distance, expert Don Jones writes.
-
Data in the fast lane: Column-store indexes in Denali
Column-store indexes in SQL Server Denali bring with them ultra-swift search capability, writes expert Roman Rehak, but in this early stage, there are limitations.
-
Master Data Services plays huge role on BI stage
Microsoft Master Data Services, the company’s master data management product, has much to offer businesses’ business intelligence efforts, according to expert Don Jones.
-
Top five features in SQL Server Developer Tools
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features.
-
SQL Server 2008 R2 SP1 not earth-shaking, but useful
SQL Server 2008 R2 Service Pack 1 has a number of new features, including a query hint, new system objects and support for up to 15,000 partitions.
-
PDW has speed, space, special requirements
Microsoft Parallel Data Warehouse is not like other software. The appliance for SQL Server 2008 R2 allows for mammoth workloads; it also has some specific data loading procedures.
-
Five mistakes companies make in SQL Server upgrades
Think your SQL Server upgrade will be a cinch? Well, it can, but thing can – and do – go wrong. Learn what not to do when moving from one SQL Server version to another.
-
SSRS best practices for a trouble-free deployment
Running SQL Server Reporting Services requires skills ranging from administration to analytical. Get advice on how to keep deployments in top shape.
-
Three tips for SQL Server upgrade, migration
Considering a SQL Server upgrade or migration? You’ll have to eventually, Don Jones writes. Get a list of pointers on successfully upgrading SQL Server.
-
BI secret to using Excel in SQL Azure: PowerPivot
So, you’re comfortable with Excel and you’ve already deployed to the cloud. Is there a trick to using Excel in Microsoft SQL Azure? Indeed there is. It’s the PowerPivot add-in.
-
Using SQL Server information schema views
SQL Server information schema views let you access metadata about database objects such tables and columns. Learn how you can access the views to retrieve relevant information.
-
Securing SQL Server data in the cloud: a few pointers
Few concerns swirling around Microsoft cloud computing are more consuming than securing SQL data in the cloud. Can it be done? Certainly, but it’s not to be taken lightly.
-
How to execute scheduled tasks in SQL Azure: Use SSIS
Without SQL Agent in SQL Azure, it can be challenging to execute schedules tasks. But it’s not impossible. Learn how using SSIS packages to simulate SQL Agent functionality can help.
-
Before scaling up Microsoft SQL Server, a few questions
Scaling up SQL Server could give your database performance a boost. First, check that your hardware is doing all it can. Learn what questions to ask before you begin an upgrade.
-
Sizing up SQL Azure limitations: There are workarounds
Considering Microsoft’s cloud database? There several SQL Azure limitations, especially on database size and how many databases you can have, but there are ways of handling them.
-
SQL server high availability and virtualization
Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.
-
When virtualizing SQL Server isn't a good idea
Virtualizing SQL Server is a good idea for many IT shops, but it's not for everyone. Robert Sheldon explains when it might not be a good choice.
-
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.