Harnessing SQL Server Metadata- Disabling And Rebuilding Indexes | Latest News RSS feed

Harnessing SQL Server Metadata- Disabling And Rebuilding Indexes - Latest News


Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

This is the first article in what I hope will be a series on leveraging the rich and varied metadata available to us in SQL Server for automating common operations. There are times when working with d... read more

Big data security analytics: Harnessing new tools for better security

How are security teams -- and indeed, the entire security industry -- seeking to turn this performance around and harness security data that continues ... of Apache open source projects and "Not Only ... read more

Update Local Data Caches with Sync Services

The second project is SSCESyncDesigner.sln, a complex, bidirectional Sync Services test harness ... changes back to SQL Server. Full-table pull updates will create and populate the table if it doesn't ... read more

Looking for another news?


Checking for Database Drift Using Extended Events and SQL Monitor

You need to make sure that nobody makes unauthorized changes to the metadata of your production databases ... You need a way to check the objects for one or more databases on the server, but not all. ... read more


A WMI Primer

If the SQL Server database is the heart of ConfigMgr ... as well as choose the WMI log location and maximum log size. In Windows Server 2008, Windows Server 2008 R2, Windows Vista, and Windows 7, you ... read more

Surendra Verma: Vista Transactional File System

for example, an important event), but even inside that process you could use it in more fine grained way, to keep your live video file recording in a consistent state so it would work without any "reb... read more

Create, Alter, and Drop Indexes: Stairway to SQL Server Indexes Level 12

Creating, altering and dropping indexes falls under the subject of index maintenance. CREATE, ALTER and DROP are the verbs for index maintenance only because the SQL Server ... rebuild, reorganize, di... read more

XFS: the filesystem of the future?

Where things have tended to fall down is in the writing of metadata; support for workloads that generate ... will also be increased. All this will enable a lot of nice things: proactive detection of f... read more

Comparing the top big data security analytics tools

RSA Security Analytics also employs a distributed, federated architecture to enable linear scaling ... in a time-partitioned way that eliminates the need for globally rebuilding indexes. It is also de... read more

Use OData Containment To Make the Easy Connections in an ASP.NET Web App

To test the application, I will create a simple HTML page (index.html) that will act as a test harness. This page will contain a few ... http://localhost:41093/odata/$metadata 2. To view current order ... read more

Getting Started with Hibernate Search

This newly updated Refcard breaks down getting started with Hibernate Search and searching your database. Learn more about configuration properties, mapping entities and executing queries, synchronizi... read more

Find all the 'son' constraints

When you want to drop a table, you typically first disable all the FKs to it. So here's a little script that gives you the "Father" table name and all of its "Sons." It has been tested on 8.1.5, 8.1.6 ... read more



FeedsRSS Created by. Full RSS Feed | Privacy Policy | Contact Us