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

<< Newer    Items 41 to 60 of 13190    Older >>
 

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: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 208 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 189 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: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 15,604 reads

Drop and Re-Create All Foreign Key Constraints in SQL Server

Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.  Read more...
By Additional Articles 2014/10/17 | Source: MSSQLTips.com | Category: foreign keys
Rating:  Rate this |   Briefcase | 7,181 reads

Who Watches the Watchers?

Who checks on those who manage our systems? Is there auditing in place for those accidental DBAs?  Read more...
By Brandie Tarvin 2014/10/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 270 reads

Troubleshoot SQL P2P replication doesn't replicate DDL schema change.

This article shows a problem with P2P replication doesn't replicate DDL schema changes and something you might want to check.  Read more...
By Yiqing (Charles) Ju 2014/10/16 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 1,018 reads

Set-based Constraint Violation Reporting in SQL Server

When you're importing data into an RDBMS in bulk and an exception condition is raised because of a constraint violation, you generally need to fix the problem with the data and try again. The error won't tell you which rows are causing the violation. What if you've thousands of rows to search when it happens? There are solutions, writes William Sisson.  Read more...
By Additional Articles 2014/10/16 | Source: SimpleTalk | Category: constraints
Rating: (not yet rated)  Rate this |   Briefcase | 7,186 reads

The 3AM Meltdown - New DBA Team Article

Where do you start fixing a SQL Server crash when there isn’t a single clue? The DBA Team had better find out quick, or they’re not going to get any sleep tonight. Find out how it all goes.  Read more...
By Additional Articles 2014/10/16 | Source: Red-Gate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 7,807 reads

Handling Inconvenient Requests

Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.  Read more...
By Brad McGehee 2014/10/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 242 reads

Stairway to SQL Server Security Level 4: Permissions

A permission gives a principal access to an object to perform certain actions on or with the object. SQL Server has a mind-numbingly huge number of permissions that you can grant to a principal, and you can even deny or revoke those permissions. This sounds a bit complicated, but by the end of this stairway level you’ll understand how SQL Server permissions work and how you can exert very granular control over object creation, data access, and other types of actions on database and server objects.  Read more...
By Don Kiely 2014/10/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,829 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2014/10/15 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 37,909 reads

Performing Azure SQL Database Management Tasks by Using PowerShell with REST API

Recently, we have been exploring the ability to administer Azure SQL Database by leveraging REST APIs invoked from PowerShell-based scripts. Such an approach offers more flexibility, facilitating functionality that is not directly exposed in the PowerShell cmdlets. In this article Marcin Policht shows the benefits when dealing directly with Azure SQL Databases.  Read more...
By Additional Articles 2014/10/15 | Source: MSSQLTips.com | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 6,796 reads

SQL Azure Point-in-Time Restore

Point-in-Time Restore is a new feature of the SQL Azure Service Tiers  Read more...
By Paul Hebhardt 2014/10/14 | Source: SQLServerCentral.com | Category: sql azure
Rating: |  Discuss |   Briefcase | 1,251 reads

Mercenary

Steve Jones talks about making deliberate career choices, or just moving from place to place without any worry about the job. Do you care about what work you do? Or is it just a job?  Read more...
By Steve Jones 2014/10/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 139 reads

Questions about Primary and Foreign Keys You Were Too Shy to Ask

It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.  Read more...
By Additional Articles 2014/10/14 | Source: SimpleTalk | Category: primary keys
Rating: (not yet rated)  Rate this |   Briefcase | 8,363 reads

SQL Monitor Custom Metric: Buffer Pressure

Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using the memory dump from DBCC MEMORYSTATUS() and comparing Target Committed to the Current Committed allocations. If you hit negative numbers you are looking at a buffer issue.  Read more...
By Press Release 2014/10/14 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,626 reads

Database Deployment Problems Survey

Red Gate is looking to build tools and features to help reduce the risk of database deployment. In order to achieve this, we need to get a better understanding of the most common deployment problems you are encountering when moving changes from development to production. Please help by filling in our two-page survey.  Read more...
By Additional Articles 2014/10/14 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 6,231 reads

Linked server creation to MySQL Server

Here is a step by step procedure to create a linked server to MySQL from SQL Server.  Read more...
By Vinayaka Gangadhar 2014/10/13 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 2,768 reads

Fine Products for the Modern Drudge

As working hours in tech trend upwards, we look at some ways to make life easier.  Read more...
By Dave Convery 2014/10/13 | Source: SQLServerCentral.com | Category: career
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

Document, then Install

Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.  Read more...
By Steve Jones 2014/10/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 84 reads
<< Newer    Items 41 to 60 of 13190    Older >>