Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

<< Newer    Items 81 to 100 of 13247    Older >>

SQL in the City London - October 24

SQL in the City London is a Red Gate event, full of SQL Server MVP training and networking. These events get bigger and bigger each year, so it's not one to be missed!  Read more...
By Press Release 2014/10/23 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 159 reads

Regaining access to SQL server after changing the domain

If you changed your domain and have lost control over the SQL server or have been blocked from logging in , this article talks about it  Read more...
By Yousef Ekhtiari 2014/10/23 | Source: | Category: change domain
Rating: |  Discuss |   Briefcase | 2,501 reads

When is 8000 too small?

Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.  Read more...
By Steve Jones 2014/10/23 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 349 reads

Building a Better NuGet

NuGet has transformed the ease of getting and installing the latest version of .NET packages, tools and frameworks. It relies on NuGet package authors to get packages right but there is little documentation for them to go by, and there are a few inevitable problems. Ed Charbeneau offers advice from experience.  Read more...
By Additional Articles 2014/10/23 | Source: SimpleTalk | Category: nuget
Rating:  Rate this |   Briefcase | 7,210 reads

The Mindset of the Enterprise DBA: Delegating Work

A lot of the routine jobs demanded of a DBA can be automated, but a tougher prospect is to automate these jobs in a way that the requestor rather than the DBA can actually set of the job running themselves without compromising security and without risk. Is it true to say that some tasks can be made self-service?   Read more...
By Additional Articles 2014/10/23 | Source: SimpleTalk | Category: delegation
Rating:  Rate this |   Briefcase | 8,113 reads

Byte Me: Hairy Situation

Poor documentation can really bristle. 
By Bob Lang 2014/10/22 | Source: | Category: byte me
Rating: |  Discuss |   Briefcase | 410 reads

Stairway to SQL PowerShell Level 8: SQL Server PowerShell Provider

In this level we continue our journey into the SQL Server space by looking at the SQL Provider that comes with modules for PowerShell. You saw a little bit of the provider for SQL 2008 R2 in Level 2 of this Stairway.  Read more...
By Ben Miller 2014/10/22 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,817 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/10/22 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 31,952 reads

Finding a table name from a page ID

Imagine you come to work in the morning and notice that some new rows have been entered into the msdb.dbo.suspect_pages table during the night. Usually the first thing you’re going to do is run DBCC CHECKDB, but if your database is a few TB, that could be several hours before you know where the problem is, and which table may have lost data. You want to find out which table is involved as soon as possible so you can explore your disaster recovery options.  Read more...
By Additional Articles 2014/10/22 | Source: SQLskills | Category: table name
Rating: (not yet rated)  Rate this |   Briefcase | 8,591 reads

Comprehensive Baseline Collector Solution

There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution  Read more...
By Robert Virag 2014/10/21 | Source: | Category: baseline
Rating: |  Discuss |   Briefcase | 3,953 reads

When Work Gets in the Way of Work

Work sometimes gets in the way of work. Steve Jones notes this can cause stress and problems over time.  Read more...
By Steve Jones 2014/10/21 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 135 reads

Exploring Your SQL Server Databases with T-SQL

Scott Swanberg shares 38 scripts he uses time and time again for discovering more about database objects.  Read more...
By Additional Articles 2014/10/21 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 9,502 reads

Survey on SSDT and Database Projects

Red Gate are developing new tools for users of SSDT and Database Projects in Visual Studio. If you use these technologies, help us make our tools ingeniously simple by completing this 10 minute survey.  Read more...
By Press Release 2014/10/21 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 13,919 reads

What To Do When the Import and Export Wizard Fails - Part I Imports

My “Success” story describes the import process when it works without a hitch, while my “Challenge” story highlights a common difficulty encountered when using the Microsoft Import and Export Wizard, and then offers a solution.   Read more...
Rating: |  Discuss |   Briefcase | 2,898 reads

Why Would You Move?

Most people prefer to work with the platforms that they are familiar with, but there is always pressure to try new, exciting technologies when others have success. Steve Jones explores the idea of switching platforms.  Read more...
By Steve Jones 2014/10/20 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

In Praise of Service Broker

Phil Factor on one of SQL Server's unsung and underused workhorses.  Read more...
By Phil Factor 2014/10/20 | Source: | Category: service broker
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

Starting as a SQL Server Business Intelligence Developer

Besides the technical skills required to be a proficient SQL Server business intelligence developer, there are numerous "soft" skills that can contribute to your success.   Read more...
By Additional Articles 2014/10/20 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 8,772 reads

SQLintersection & DEVintersection Conference Descends On Las Vegas November 10-13

DevIntersection and SQLIntersection conference will bring together experts from Microsoft, SQLSkills, .NET Rocks, and 90 industry gurus.   Read more...
By Press Release 2014/10/20 | Source: | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 216 reads

It's about Perception

What's the most important thing about your application? The code? The accuracy of its calculations? The layout of the reports? Steve Jones has another opinion.  Read more...
By Steve Jones 2014/10/17 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 193 reads

5 Reasons You Must Start Capturing Baseline Data

It is widely acknowledged within the SQL Server community that baselines represent valuable information that DBAs should capture. Unfortunately, very few companies manage to log and report on this information, and DBAs are then forced to troubleshoot from the hip and scramble to find evidence to prove that the database is not the problem. This article will make a compelling argument for why DBAs must start capturing baseline information, and will create a roadmap for subsequent posts.  Read more...
By Erin Stellato 2014/10/17 (first published: 2012/11/19) | Source: | Category: baselines
Rating: |  Discuss |   Briefcase | 15,963 reads
<< Newer    Items 81 to 100 of 13247    Older >>