9/08
Proactive caching helps DBAs to better control
the cube data automatic refresh frequency, offering near real-time data for
reports. This article covers the settings for HOLAP and ROLAP, and configuring
proactive caching. 9/07
SQL Azure Data Sync provides data synchronization between the cloud and local SQL Server databases. Learn how SQL Azure Data Sync allows you to keep the most concurrent information in the cloud while allowing mobile users, businesses, and enterprise data sources all to have access to this data.
9/03
The questions you may wish to ask or that will be asked during a SQL Server Developer interview will vary. Deanna Dicken shares the top 9 interview questions she asks when interviewing a potential SQL Server developer.
9/02
Learn how to consume and make use of the ADO.NET Data Service in a .NET Framework Client Application. This article demonstrates the process by creating a simple web application that uses an existing ADO.NET Data Service.
9/02
Arshad Ali explores Proactive Caching, available in SQL Server Analysis Services 2005 and later versions. Proactive Caching helps DBAs to better control the cube data automatic refresh frequency. Proactive Caching offers near real time data for reports, while at same time providing a query performance similar to MOLAP storage mode.
8/31
DBAs often have a need to identify why a problem has occurred, or is occurring in their SQL Server database. This article covers some of the tools you can use to look for clues, and the steps you might go through to help troubleshoot a SQL Server problem.
8/27
Protecting database information from threats and vulnerabilities is vital for any organization. This article discusses 10 new security features introduced in SQL server 2008 that facilitate effective management of the database by using server surface area configuration (policy-based management configuration), full database encryption (TDE), enhanced auditing features and more.
8/25
No programming skills? No problem. Microsoft Visual Studio LightSwitch is all about building data-centric applications and all of the plumbing necessary to make the database connections is done for you behind the scenes. Read along as we look at what this tool can do for you.
8/24
This article discusses Database Instant File Initialization, which instructs the OS to allocate the required disk space immediately before actually zero-ing out the content from the allocated space. This means the content of the allocated disk area remains there until SQL overwrites it, improving the performance and reducing the downtime. Read on to learn more...
8/23
While it is very common to store SSIS packages created using SQL Server Business Intelligence Development Studio in the file system, it is important to realize that there are other options. This article provides a comprehensive overview of all of the options, including their benefits and drawbacks, focusing on their ability to protect package content from unauthorized changes.
8/20
As enterprises add systems and acquire companies, they will most likely find themselves faced with a growing inconsistency amongst core data utilized by their key systems. This leads to an inability to provide quality data to management. Master Data Services for SQL Server provides a means to centrally manage and serve up this critical enterprise data.
8/13
Fragmentation relates to index entries that are out of sequence, which for queries that access data sequentially, leads to additional work to retrieve the index's data. This excerpt from the book SQL Server DMVs in Action discusses a script for identifying the most fragmented indexes. Fragmentation affects query performance and should be removed.
8/10
SQL server 2008 improves developer productivity by providing seamless integration between frameworks, data connectivity technologies, programming languages, Web services, development tools and data. This article covers the top 10 developer features introduced in SQL server 2008.
8/09
Learn how the DTExec and DTExecUI utilities give you the ability to assign values to arbitrary properties of components within a SQL Server Integration Services package, when invoking its execution.
8/06
Cursors provide a means of
processing through a set of records row-by-row. However, many companies have a
policy against using cursors in their SQL Server standards. This article examines the
problem with cursors and alternatives to using them.
