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

   Items 1 to 20 of 13320    Older >>
 

GUIDs GUIDs everywhere, but how is my data unique?

After having seen many systems that use GUIDs as the primary key for every table, it is time to say enough is enough.  Read more...
By Thomas Romeo 2014/12/18 | Source: SQLServerCentral.com | Category: guid
Rating: |  Discuss |   Briefcase | 4,978 reads

Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask

Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for your query? If you get this wrong, the consequences can be serious. Deadlocks, Dirty reads, Non-repeatable reads, or poor performance. We're in luck, because Robert Sheldon once more answers those questions that are awkward to ask in public.  Read more...
By Additional Articles 2014/12/18 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,606 reads

Deleting Data

The "right to be forgotten" law in Europe has Steve Jones a bit worried.  Read more...
By Steve Jones 2014/12/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

Byte Me: Yule Log On

Festive cheer on display.  Read more...
By Bob Lang 2014/12/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 319 reads

Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.  Read more...
By Gregory Larsen 2014/12/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,401 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/12/17 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 43,185 reads

Introduction to Azure SQL Database Scalability

One of the primary advantages of Platform-as-a-Service solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,172 reads

What To Do When the Import and Export Wizard Fails - Part II Exports

This article will discuss a case study of utilizing a SSIS package to export a table that has columns with data type varchar(mx) and text to an Excel file.   Read more...
Rating: |  Discuss |   Briefcase | 2,281 reads

Go Small

The SQL Server community is amazing, and Steve Jones hopes we continue to be close as we grow. He brings light on an idea to grow us larger, but smaller.  Read more...
By Steve Jones 2014/12/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads

Tribal Awards Finalists

Voting is now open for the Tribal Awards. Vote for one of the 5 finalists in each category to win a fabulous* prize.   Read more...
By Press Release 2014/12/16 | Source: SQLServerCentral.com | Category: awards
Rating: |  Discuss |   Briefcase | 986 reads

SQL Server Reporting Services Basics: The Visual Controls

Kathi Kellenberger demonstrates how to start adding visual flair to your SSRS reports, using its impressive set of visual controls, ranging from basic charts to gauges, indicators, sparklines, and maps.  Read more...
By Additional Articles 2014/12/16 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 4,091 reads

Adding a Query Governor to Dynamic-Search Stored Procedures

When undisciplined users access your search forms, you can control their behavior and limit the results they're presented with in various ways.  Read more...
By Dwain Camps 2014/12/15 | Source: SQLServerCentral.com | Category: dynamic search
Rating: |  Discuss |   Briefcase | 3,459 reads

Drop and Recreate

Steve Jones notes that disasters come in all shapes and sizes, but a little prep that you might not have thought of can reduce the scale of the issues.  Read more...
By Steve Jones 2014/12/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 125 reads

Debugging Natively-Compiled Stored Procedures Statements

Considering that SQL Server 2014 Natively Compiled Stored Procedures are compiled into binary code, you may have asked yourself if it's possible to monitor statement execution. In this tip Daniel Farina explains how you can monitor SQL Server Natively Compiled Stored Procedures.  Read more...
By Additional Articles 2014/12/15 | Source: MSSQLTips.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 4,610 reads

Data Security Woes

Another week, and another set of data security issues around the world.  Read more...
By Steve Jones 2014/12/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 61 reads

What, when and who? Auditing 101 - Part 2

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...
By Roy Ernest 2014/12/12 (first published: 2012/01/16) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 11,559 reads

The Last Job

Steve Jones contemplates employment and the future of the last job he'll have. This Friday he asks you if this might be yours.  Read more...
By Steve Jones 2014/12/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

Finding SQL Server views with (or without) a certain property

In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.  Read more...
By Additional Articles 2014/12/12 | Source: MSSQLTips.com | Category: views
Rating: (not yet rated)  Rate this |   Briefcase | 4,206 reads

A Spectacular Case of 100% CPU Caused by Online Reindexing

An investigation of a serious performance issue during online re-indexing on a production server leads us to interesting discoveries and solutions.  Read more...
By Viktor Gorodnichenko 2014/12/11 | Source: SQLServerCentral.com | Category: execution plan
Rating: |  Discuss |   Briefcase | 5,948 reads

Citizen Programmers

Steve Jones finds the Salesforce platform interesting and notes we have lots of "citizen programmers" doing work with data.  Read more...
By Steve Jones 2014/12/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads
   Items 1 to 20 of 13320    Older >>