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

<< Newer    Items 61 to 80 of 15998    Older >>
 

Getting Started with SQL Server 2012 Express LocalDB

Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task.  Read more...
By Additional Articles 2017/07/28 | Source: MSSQLTips.com | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 4,663 reads

Simple Talk is hiring a full-time editor

Have experience editing and writing technical content? Redgate is currently hiring for their educational publishing site, Simple Talk. They're open to accepting remote workers, so if you're interested, there's no excuse not to go ahead and apply!  Read more...
By Site Owners 2017/08/01 (first published: 2017/07/28) | Source: Redgate | Category: hiring
Rating: (not yet rated)  Rate this |   Briefcase | 4,476 reads

Advanced Analytics with R and SQL Part II - Data Science Scenarios

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.   Read more...
By Frank A. Banin 2017/07/27 | Source: SQLServerCentral.com | Category: data science
Rating: |  Discuss |   Briefcase | 816 reads

Statistics in SQL: The Kruskal–Wallis Test

Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis test is a safe way of determining whether samples come from the same population, because it is simple and doesn't rely on a normal distribution in the population. This allows you a measure of confidence that your results are 'significant'. Phil Factor explains how to do it.  Read more...
By Additional Articles 2017/07/27 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,639 reads

Who's Smarter? Humans or AI Systems?

The growth of AI has Steve Jones a bit worried.  Read more...
By Steve Jones 2017/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

SQL Crossword #1

Today we start a new puzzle series, with a crossword puzzle from MVP Kenneth Fisher.  Read more...
By Kenneth Fisher 2017/07/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 218 reads

SQL-On-Hadoop: Hive - Part I

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/07/26 | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 915 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2017/07/26 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 85,595 reads

How to Read the Transaction Log File

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.  Read more...
By Additional Articles 2017/07/26 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 4,922 reads

Azure DWH part 12: Permissions, roles, logins and users

In this article we will show some common roles and queries related to Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2017/07/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 347 reads

Containers for enhanced Data Governance and Compliance

Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.  Read more...
By Paul Stanton 2017/07/25 | Source: SQLServerCentral.com | Category: windocks
Rating: |  Discuss |   Briefcase | 245 reads

Advancing Security

Microsoft is working to provide better patches for us.  Read more...
By Steve Jones 2017/07/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects

Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.  Read more...
By Additional Articles 2017/07/25 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,438 reads

The Case of the Space at the End

A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting?  Read more...
By Adam St. Pierre 2017/07/24 | Source: SQLServerCentral.com | Category: ansi_padding
Rating: |  Discuss |   Briefcase | 1,679 reads

The Financial DBA

The future of the DBA might include lots of asset tracking and financial meetings.  Read more...
By Steve Jones 2017/07/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads

Extending DevOps practices to SQL Server databases – Branching & Merging with VSTS

Join Microsoft Data Platform MVP Steve Jones for the next Database DevOps demo webinar on July 25. He’ll be plugging Redgate tools into Visual Studio Team Services and showing how you can branch and merge your database changes. Sign up now.  Read more...
By 2017/07/24 (first published: 2017/07/20) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 10,369 reads

Testing DML Statements for In-Memory OLTP

Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.  Read more...
By Additional Articles 2017/07/24 | Source: SQLPerformance.com | Category: dml
Rating: (not yet rated)  Rate this |   Briefcase | 4,224 reads

Looking Back

Today Steve Jones takes a look back at software during his career.  Read more...
By Steve Jones 2017/07/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 89 reads

SQL Server Management Studio add-ins

Complete list of useful and must have add-ins for SQL Server Management Studio - 32 SSMS add-ins  Read more...
By Konstantin Taranov 2017/07/21 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 2,686 reads

SQL Server User-Defined Functions

User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax.  Read more...
By Additional Articles 2017/07/21 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,222 reads
<< Newer    Items 61 to 80 of 15998    Older >>