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

<< Newer    Items 81 to 100 of 16172    Older >>
 

Interviews: What is ACID?

While thinking about interviews, Steve Jones shares a story of a job situation he encountered.  Read more...
By Steve Jones 2017/09/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 114 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2017/09/20 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 96,417 reads

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.  Read more...
By Additional Articles 2017/09/20 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,661 reads

Moving beyond principal components analysis

Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.  Read more...
By Nick Burns 2017/09/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 454 reads

The Library Job Hunt

Find a new career in the library.  Read more...
By Steve Jones 2017/09/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Searching and finding a string value in all columns in a SQL Server table

Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".  Read more...
By Additional Articles 2017/09/19 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,476 reads

Benchmark your Database DevOps maturity level

Whether you’re only just starting to explore the advantages of DevOps or you’re already fully immersed in the journey, including the database brings additional advantages. Take a few minutes to complete our Database DevOps Maturity Assessment and you’ll better understand how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers.  Read more...
By 2017/09/28 (first published: 2017/09/19) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,365 reads

The Full Court CosmosDB Press

Microsoft is pushing CosmosDB quite a bit this year.  Read more...
By Steve Jones 2017/09/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 42 reads

The Instance ID MSSQLSERVER Is Already In Use

This article will explain how to fix "The Instance ID 'MSSQLSERVER' Is Already In Use By SQL Server Instance 'MSSQLSERVER.INACTIVE' Error.   Read more...
By Nisarg Upadhyay 2017/09/18 | Source: SQLServerCentral.com | Category: mssqlserver
Rating: |  Discuss |   Briefcase | 716 reads

Avoiding the Hell of having to Remember DDL syntax

What's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.  Read more...
By Phil Factor 2017/09/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 66 reads

How to Drop All Your Indexes – Fast

You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.  Read more...
By Additional Articles 2017/09/18 | Source: Brent Ozar Unlimited Blog | Category: drop indexes
Rating: (not yet rated)  Rate this |   Briefcase | 4,335 reads

Redgate wants your opinion

Have you tried or used SQL Prompt? Redgate is running some research on SQL Prompt pricing. Please help by filling in their short survey for the chance to win one of three licenses of SQL Prompt or a Redgate point-tool if your choice.  Read more...
By 2017/09/18 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,151 reads

A Pattern for Email Address storage and retrieval

Email addresses are very prevalent in IT systems and often used as a natural primary key. The repetitive storage of email addresses in multiple tables is a bad design choice. Following is a design pattern to store email addresses in a single table and to retrieve them efficiently.  Read more...
By Jeff Reinhard 2017/09/15 (first published: 2015/09/24) | Source: SQLServerCentral.com | Category: email address
Rating: |  Discuss |   Briefcase | 7,083 reads

Voting for Change

Microsoft changed some things in SQL Server 2017 in response to community requests. Steve Jones is asking for more.  Read more...
By Steve Jones 2017/09/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

SQL Server R Services: Digging into the R Language

It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.  Read more...
By Additional Articles 2017/09/15 | Source: SimpleTalk | Category: sql server r services
Rating:  Rate this |   Briefcase | 4,942 reads

Automate MSBI deployments Using PowerShell

There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.  Read more...
By Kunal Rathi 2017/09/14 | Source: SQLServerCentral.com | Category: msbi
Rating: |  Discuss |   Briefcase | 527 reads

I Will Write Bad Code

Steve Jones knows he'll write code that has issues. He plans for that.  Read more...
By Steve Jones 2017/09/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 89 reads

sp_AllNightLog: Creating Jobs Like I’m The President

Erik Darling explains why sp_AllNightLog creates so many jobs by default.  Read more...
Rating:  Rate this |   Briefcase | 4,346 reads

Extending DevOps practices to SQL Server databases with ReadyRoll from Redgate

In this webinar, Microsoft MVP Steve Jones and Redgate’s Arneh Eskandari will show you how Redgate’s Database DevOps solution can work to improve your database development and deployment processes. You'll see a demo of the following Redgate tools - ReadyRoll, DLM Automation and DLM Dashboard - and see how they plug into GIT. There will also be plenty of time to ask Steve and Arneh questions.   Read more...
By 2017/09/25 (first published: 2017/09/14) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 8,197 reads

Moving Dynamic Data Masked Data to New Locations

In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.  Read more...
By Steve Jones 2017/09/13 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 368 reads
<< Newer    Items 81 to 100 of 16172    Older >>