SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

SQL Server Dynamic Online Catalog: Why Should You Care? Stairway to Exploring Database Metadata Level 1

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.  Read more...
By Phil Factor 2018/05/09 (first published: 2016/08/03) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,025 reads

Anonymisation Confusion

Steve talks about the difference between anonymisation and pseudonymisation, which can be confusing.  Read more...
By Steve Jones 2018/05/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 59 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2018/05/09 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 94,378 reads

Kafka Integration with HDInsight

Microsoft HDInsight is the cloud service that deploys and provisions Hadoop clusters on the Azure cloud. It's a completely managed, open source analytics service to support enterprise needs and supports a wide variety of scenarios with the help of open source frameworks like Hadoop, Storm, Spark, R Server and Hive.  Read more...
By Additional Articles 2018/05/09 | Source: Database Journal | Category: hdinsight
Rating: (not yet rated)  Rate this |   Briefcase | 2,467 reads

SQL Server From .Net: Connecting Visual Studio Community Edition

This is a short description of how to connect the free Visual Studio Community Edition to the free SQL Server Express edititon.  Read more...
By Tim Wellman 2018/05/08 | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 130 reads

Reading Through the Logs

The problems at TSB Bank in the UK have Steve worried about his own records.  Read more...
By Steve Jones 2018/05/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 70 reads

Provisioning SQL Server Instances with Docker

With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker.  Read more...
By Additional Articles 2018/05/08 | Source: SimpleTalk | Category: docker
Rating: (not yet rated)  Rate this |   Briefcase | 5,060 reads

Join the leading experts in data governance and SQL Server at Redgate’s SQL Privacy Summit

The GDPR is almost here and, just one week before it’s launch, Redgate is hosting the first SQL Privacy Summit in London. The schedule of presentations, panel discussions and workshops has been created to help SQL Server professionals ensure their business meets the new data privacy and protection regulations.  Read more...
By 2018/05/08 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,053 reads

Friday the 13th

Looking forward to the next few ones of these scary days?  Read more...
By Jan Van der Eecken 2018/05/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 831 reads

Pride in Azure SQL Database

Microsoft is proud of their work on Azure SQL Database.  Read more...
By Steve Jones 2018/05/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 45 reads

So what is data mapping and why is it the key to GDPR compliance?

The GDPR brings new responsibilities for organizations which need to store and process personal data. Plan for it in the right way, however, and the journey to compliance will be a lot easier.  Read more...
By 2018/05/07 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 3,834 reads

The Technology Journey to Disaster

Phil Factor on a journey that started with a decision to introduce a new IT platform, and ended in a disaster that left TSB customers locked out of their accounts, experiencing problems such as zero balances, incorrect currencies, and massively inflated mortgage amounts.  Read more...
By Phil Factor 2018/05/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Parking Garages And Predicates

You lost your car in a big parking lot. Erik Darling explains how this is just like an index scan.  Read more...
By Additional Articles 2018/05/07 | Source: Brent Ozar Unlimited Blog | Category: predicates
Rating: (not yet rated)  Rate this |   Briefcase | 2,854 reads

Navigating Hadoop Resources

Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.  Read more...
By Daniel Klionsky 2018/05/04 (first published: 2015/10/01) | Source: SQLServerCentral.com | Category: big data
Rating: |  Discuss |   Briefcase | 4,213 reads

Intrinsic or Extrinsic

Today Steve Jones asks what your motivations are for your career choices.  Read more...
By Steve Jones 2018/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 51 reads

“But I don’t need to back up that database.”

Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.  Read more...
By Additional Articles 2018/05/04 | Source: Brent Ozar Unlimited Blog | Category: backups
Rating:  Rate this |   Briefcase | 3,983 reads

Avoid use of the MONEY and SMALLMONEY datatypes

One of SQL Prompt's code analysis recommendations is that you avoid using the MONEY and SMALLMONEY datatypes - this article from Phil Factor explains why.  Read more...
By 2018/05/04 | Source: Redgate | Category: code analysis
Rating:  Rate this |   Briefcase | 4,294 reads

Scripting Objects with PowerShell

In the third installment of this series, Steve Jones uses PowerShell to source control code.  Read more...
By Steve Jones 2018/05/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 810 reads

150 SQL Code Smells

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. SQL Prompt is committed to cover as many as possible of them. Phil has also updated his book, which is free to download.  Read more...
By Additional Articles 2018/05/03 | Source: SimpleTalk | Category: code smells
Rating: (not yet rated)  Rate this |   Briefcase | 5,681 reads

Reasons to Upgrade

There are always reasons to upgrade or avoid upgrading to a new version. Steve Jones has a few thoughts.  Read more...
By Steve Jones 2018/05/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads
<< Newer    Items 41 to 60 of 16820    Older >>