Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 14920    Older >>
 

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.  Read more...
By Gregory Larsen 2016/07/29 (first published: 2014/07/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,815 reads

Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation

Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.  Read more...
By Additional Articles 2016/07/29 | Source: MSSQLTips.com | Category: dbcc shrinkfile
Rating: (not yet rated)  Rate this |   Briefcase | 2,170 reads

How Far Have You Traveled for a SQL Saturday?

This Friday Steve Jones talks SQL Saturdays and asks how far you've traveled to attend one.  Read more...
By Steve Jones 2016/07/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Data Quality - Addressing non-stated requirements

Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.  Read more...
By David Poole 2016/07/28 | Source: SQLServerCentral.com | Category: data quality
Rating: |  Discuss |   Briefcase | 839 reads

Too Much Information for Sports

Gathering too much data isn't always helpful, and doesn't necessarily help you make better decisions. However, that's up to you to decide how much is too much.  Read more...
By Steve Jones 2016/07/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

A Real-World React.js Setup for ASP.NET Core and MVC5

React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework.  Read more...
By Additional Articles 2016/07/28 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 1,558 reads

Learning to Search

Today Steve Jones notes that the ability to search if invaluable as the amount of information, or even objects, we deal with grows.  Read more...
By Steve Jones 2016/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 62 reads

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.  Read more...
By Mike McQuillan 2016/07/27 | Source: SQLServerCentral.com | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 212 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 2016/07/27 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 75,391 reads

Temporal Data Part 2 - Creating and Deleting System-Versioned Tables

Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.  Read more...
By Additional Articles 2016/07/27 | Source: Database Journal | Category: temporal data
Rating: (not yet rated)  Rate this |   Briefcase | 1,429 reads

A Buggy Release

Releasing software is stressful, and as Steve Jones notes today, can cause bankruptcy if you don't have a solid process.  Read more...
By Steve Jones 2016/07/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Azure SQL Limitations compared with a SQL Server Enterprise

In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.  Read more...
By Daniel Calbimonte 2016/07/26 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 1,471 reads

What's "Actually" going on with that Seek?

Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.  Read more...
By Additional Articles 2016/07/26 | Source: SQLPerformance.com | Category: seeks
Rating: (not yet rated)  Rate this |   Briefcase | 2,317 reads

Redgate’s 2016 Roadmap

What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this year. Find out more.  Read more...
By Additional Articles 2016/07/26 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,687 reads

Where's the Unit Testing?

Today Steve Jones wonders why we don't unit test more, especially for databases.  Read more...
By Steve Jones 2016/07/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

Analyzing Data in Real Time

What is real time data analysis? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2016/07/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 47 reads

Additional Data Files and Proportional Fill

Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads data across multiple files.  Read more...
By David Fundakowski 2016/07/25 | Source: SQLServerCentral.com | Category: filegroups
Rating: |  Discuss |   Briefcase | 919 reads

The IT Manager's perspective: People as an Asset

Information Technology is fast-changing, but the people who work in IT need to have a good chance of a long-term career. That means keeping up to date, not only in their current speciality, but in the wider sphere of the technology they work with. IT managers must make sure that keeping up to date with technology is part of the day to day activity of their people. How should they make sure it happens?  Read more...
By Additional Articles 2016/07/25 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 2,184 reads

Stairway to T-SQL: Beyond The Basics Level 4: Using Views to Simplify Your Query

This level discusses how to use a database VIEW to simplify your Transact-SQL(T-SQL) code. By understanding how to use a VIEW you will be able to better support writing T-SQL code to meet complex business requirements. In this article I will be discussing what a database VIEW is and then providing a number of examples to help you understand how you can use a VIEW to implement different coding scenarios.  Read more...
By Gregory Larsen 2016/07/22 (first published: 2014/03/19) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,213 reads

How do you know when it is time to leave a job?

Today we have a guest editorial from Ben Kubicek as Steve is traveling out of town. I discovered I had stayed at a job about two years too long. Why was that?  Read more...
By Ben Kubicek 2016/07/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 138 reads
   Items 1 to 20 of 14920    Older >>