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

   Items 1 to 20 of 17655    Older >>
 

Using SQL Server and R Services for analyzing DBA Tasks

Article shows how R Services can help database administrators with their daily work   Read more...
By Tomaž Kaštrun 2019/02/22 (first published: 2017/02/07) | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,812 reads

The risks of using EXECUTE (‘SQL Script’)

Using dynamic SQL is unavoidable at times, but it is reckless to execute dynamic SQL that is created directly from strings that include values that change at execution time. It can allow SQL Injection and it is also inefficient.  Read more...
By 2019/02/22 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,899 reads

An Introduction to GitHub for DBAs

Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved?  Read more...
By Additional Articles 2019/02/22 | Source: Brent Ozar Unlimited Blog | Category: github
Rating: (not yet rated)  Rate this |   Briefcase | 2,394 reads

A Good Benefit?

A company is letting companies trade vacation for payments against student loan debt.  Read more...
By Steve Jones 2019/02/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 31 reads

Treat All Sensitive Data as Important

No matter what the reason you have sensitive information, you need to treat it carefully.  Read more...
By Steve Jones 2019/02/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 26 reads

A Sudoku Solver for Ordinary folk

Solving Sudoku in smaller, simpler steps  Read more...
By Pete Revell 2019/02/21 | Source: SQLServerCentral.com | Category: sudoku
Rating: |  Discuss |   Briefcase | 929 reads

Gartner’s 2018 Market Guide for Data Masking available to download complimentary of Redgate

With the introduction of GDPR in 2018, new data privacy acts appearing around the globe and a striking rise in high-profile data breaches, data masking is a popular topic from IT floor to the board room. Gartner released their 2018 Market Guide for Data Masking covering their analysis, recommendations, and representative vendors – including Redgate. To find out more, get your complimentary copy of the report from Redgate.   Read more...
By 2019/02/21 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,501 reads

The BI Journey: The Analyst

Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are just getting started. This article, by Data Platform MVP Gogula Aryalingam, describes how analytics can start small – with just one Power BI dashboard – and grow from there.  Read more...
By Additional Articles 2019/02/21 | Source: SimpleTalk | Category: bi
Rating:  Rate this |   Briefcase | 2,388 reads

Default Security

Ensure that when you set up a new system, you include some sort of security.  Read more...
By Steve Jones 2019/02/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

Stairway to MDX - Level 14: Basic Set Functions: The Head() Function

SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Head() function, which allows us to return, in order, a specified number of elements within a set.  Read more...
By Bill Pearson 2019/02/20 (first published: 2015/09/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,192 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 2019/02/20 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 105,691 reads

On Quickly Investigating a SQL Monitor Custom Security Alert

Phil Factor offers a clever way to report on an intrusion, with a query that shows a full ‘narrative’ description of all the changes that have been detected by SQL Monitor. Using the results, the DBA can very quickly investigate the sequence of unusual events.   Read more...
By 2019/02/20 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,998 reads

Azure Data Lake Analytics using U-SQL Queries

This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.  Read more...
By Additional Articles 2019/02/20 | Source: MSSQLTips.com | Category: azure data lake
Rating: (not yet rated)  Rate this |   Briefcase | 1,596 reads

How Perfect Should Our Software Be?

Steve talks about the level of engineering effort we need in software development.  Read more...
By Steve Jones 2019/02/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Learning about DML Triggers

Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.  Read more...
By Steve Jones 2019/02/19 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 507 reads

Picking over the Bones of a SQL Injection Attack

The best way to learn how to protect your databases from SQL Injection is to see it in action. In this article, we attack a vulnerable SQL Server REST interface, explain how the attack unfolds, the mistakes that made it possible, and SQL Monitor's vital role as the 'canary in the mine'.  Read more...
By 2019/02/19 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,918 reads

Top 10 Databases for 2019

A look at ten top databases fighting for mind-share in 2019.  Read more...
By Additional Articles 2019/02/19 | Source: Database Journal | Category: database
Rating:  Rate this |   Briefcase | 4,759 reads

GDPR - A guide for the perplexed

If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?  Read more...
By David Poole 2019/02/18 (first published: 2018/01/11) | Source: SQLServerCentral.com | Category: gdpr
Rating: |  Discuss |   Briefcase | 2,841 reads

We Want Maturity, But Is It Fun?

By Andy Warren 2019/02/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 186 reads

You Need Offline Backups

Steve talks about the need to be careful with backups in this age of malicious attackers.  Read more...
By Steve Jones 2019/02/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads
   Items 1 to 20 of 17655    Older >>