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

<< Newer    Items 21 to 40 of 16811    Older >>
 

How do you deal with disappointment?

Disappointment is hard, but you get to choose how you react to it.  Read more...
By Ben Kubicek 2018/05/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

Auto assign Column Data Types for Flat file Source Import

A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again!   Read more...
Rating: |  Discuss |   Briefcase | 768 reads

SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database

The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships.  Read more...
By Additional Articles 2018/05/14 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 3,079 reads

Strange Filtered Index Problem

What I thought was a strange filtered index problem but turned out to be a DB settings problem  Read more...
By Mike Good 2018/05/11 (first published: 2015/08/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,442 reads

Interviewing Avatars

Maybe you'll be able to send your avatar to an initial phone screen one day.  Read more...
By Steve Jones 2018/05/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Create Azure VMs with PowerShell Part 1

Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM.  Read more...
By Additional Articles 2018/05/11 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,284 reads

Automatic Provisioning of Developer Databases with SQL Provision

This article shows a simple proof-of-concept workflow that allows an organization to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process.  Read more...
By 2018/05/11 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,559 reads

Power BI Desktop on the Mac

By Steve Jones 2018/05/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 27 reads

One Million Tables

A quick experiment to create one million tables in a database.  Read more...
By Steve Jones 2018/05/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,272 reads

Setting up SQL Server on Red Hat Linux in AWS - Part 1

In this post, Pinakin Patel looks at the preliminary steps you need to peform to build an instance in AWS to run SQL Server on Red Hat Linux.  Read more...
By Additional Articles 2018/05/10 | Source: MSSQLTips.com | Category: sql server on linux
Rating: (not yet rated)  Rate this |   Briefcase | 2,762 reads

SQL Compare Snapshots: a lightweight database version control and rollback mechanism

SQL Compare snapshots provide an easy way to keep track of changes during development work, whether they are small changes between iterations, or significant changes between releases. Snapshots can be used to quickly generate rollback scripts during releases even in environments which are isolated by infrastructure design for security reasons.  Read more...
By 2018/05/10 | Source: Redgate | Category: version control
Rating: (not yet rated)  Rate this |   Briefcase | 2,511 reads

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,022 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 | 57 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,312 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,357 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 | 69 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 | 4,979 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,003 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 | 829 reads
<< Newer    Items 21 to 40 of 16811    Older >>