Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 15575    Older >>
 

Performaing a Right and Comprehensive Age Calculation Part 2

Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.  Read more...
By Sergiy Floka 2017/03/30 | Source: SQLServerCentral.com | Category: age calculation
Rating: |  Discuss |   Briefcase | 633 reads

What's New in Master Data Services MDS 2016 - Part 1

SQL Server 2016 introduced many new features and improvements for all its products, and Master Data Services (MDS) is no exception. In this post, Koen Verbeeck gives a comprehensive overview of all the new MDS features.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,362 reads

Is work just work?

Are you enjoying your work?  Read more...
By Nitin Bhojwani 2017/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 58 reads

Audit and compliance survey with prize draw

The Foundry team at Redgate have been investigating how different regulations impact work with SQL Server. They understand the many regulations, but need your help to get a better idea of all the related activities. How has your experience with auditing and compliance been in the past? Fill out this short survey to let the team know, and in return you'll be entered into a draw to win a $100 Amazon gift card.  Read more...
By 2017/03/30 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 623 reads

Big Companies are Improving with DevOps

Steve Jones notes that not just the small, startup, agile companies use DevOps. Nor is it just technology companies.  Read more...
By Steve Jones 2017/03/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 26 reads

Justify the Remote access requirement for Biztalk Log Shipping

This article will show why there is a need for remote access with a Biztalk server that uses log shipping.  Read more...
By Bilal Ayub 2017/03/29 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 231 reads

Handling Graphs in SQL

Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are graphs in which attributes can be associated with the nodes and edges. It is a natural way to study relationships within the data. SQL databases aren't the easiest way of doing it, but it makes sense where the scale permits it. Because of the range of graphs and techniques, some Graph theory is unavoidable before you get stuck into the code, and who better to introduce graph databases than Joe Celko?  Read more...
By Additional Articles 2017/03/29 | Source: SimpleTalk | Category: graphs
Rating: (not yet rated)  Rate this |   Briefcase | 2,841 reads

Hacked

Getting hacked is no fun. Today Steve Jones notes he's been hacked, in more ways than one and wants you to think about this at your workplace.  Read more...
By Steve Jones 2017/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 322 reads

Performing a Right and Comprehensive Age Calculation

Age calculation based on the right method used in real life.   Read more...
By Sergiy Floka 2017/03/28 | Source: SQLServerCentral.com | Category: datetime conversions
Rating: |  Discuss |   Briefcase | 1,436 reads

Who Changed My Database Schema?

Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.  Read more...
By Additional Articles 2017/03/28 | Source: Database Journal | Category: schema
Rating:  Rate this |   Briefcase | 3,068 reads

Is Big Data good for Data Professionals?

Is Big Data good for us? Steve Jones thinks it is.  Read more...
By Steve Jones 2017/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 396 reads

Create reports in Azure SQL Data Warehouse using SSRSS

In this article, we will show how to create reports in ASDW using SSRS  Read more...
By Daniel Calbimonte 2017/03/27 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 544 reads

Using AT TIME ZONE to fix an old report

Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.  Read more...
By Additional Articles 2017/03/27 | Source: SQLPerformance.com | Category: at time zone
Rating: (not yet rated)  Rate this |   Briefcase | 2,498 reads

I'm "working from home"

Phil Factor argues that The serious problems with working from home come not from poor productivity, but when office-based team members seem to prefer to ignore the fact that the remote workers exist.  Read more...
By Phil Factor 2017/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 84 reads

Change Approvals

Who decides when code should be released? A question from Steve Jones today.  Read more...
By Steve Jones 2017/03/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

The Mysterious Case of the Missing Default Value

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.  Read more...
By Raul Gonzalez @SQLDoubleG 2017/03/24 (first published: 2015/12/01) | Source: SQLServerCentral.com | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,409 reads

Encrypting SQL Server: Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,119 reads

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 669 reads

Getting Started with Azure SQL Data Warehouse - Part 2

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,784 reads

I Hate To Send This Email

Steve Jones wonders how many of us have had to send, or will have to send this email.  Read more...
By Steve Jones 2017/03/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 117 reads
   Items 1 to 20 of 15575    Older >>