Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/07/10 to 2013/07/17

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 2014/12/17 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 44,679 reads

What is Biml? - Level 1

An introduction to the Biml language from Andy Leonard that helps  Read more...
By Andy Leonard 2014/11/12 (first published: 2013/07/17) | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 30,210 reads

Biml Workshop presented by Varigence and Linchpin People

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. On October 15th come see why BI professionals around the world think Biml is the future of data integration and BI.   Read more...
By Press Release 2013/08/07 (first published: 2013/07/17) | Category: events
Rating:  Rate this |   Briefcase | 5,975 reads

SQL Saturday #222

SQL Saturday is coming to Sacramento on July 27, 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday also features a paid-for full day pre-con session with Kalen Delaney  Read more...
By Press Release 2013/07/17 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 405 reads

SQL Server Transactions and Locking – Part 2

This article looks at SQL Server locking and transaction isolation levels, how to set the transaction isolation level, and how some isolation levels use locking, while others use row versioning. It also explains what type of locks data update requires.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,315 reads

Orphaned Distribution Transactions

Learn about orphaned distribution transactions in SQL Server and how you can clear them.  Read more...
By Shashank Srivastava 2013/07/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,688 reads

SQL Server Central Webinar Series #24: Prepare for When Disaster Strikes

Our next webinar on July 23rd has Steve Jones presenting on some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.  Read more...
By Press Release 2013/07/23 (first published: 2013/07/03) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,609 reads

SQL Saturday #231 Cocoa Beach

Join us for a free day of SQL Server training and networking on July 27 in Cocoa Beach, Florida.  Read more...
By Press Release 2013/07/16 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,967 reads

Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

Some companies put business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual in companies that use the SQL Server layer to perform business tasks, such as finance operations, or incorporate application functionality into the programmability layer. Here's a tip to preserve secrecy on some procedures, views or functions in order to maintain security.  Read more...
By Additional Articles 2013/07/16 | Source: MSSQLTips.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 3,017 reads

Parameter Sniffing and Sniffing Memory

This article aims to demonstrate bad parameter sniffing and its effects on memory grants.  Read more...
By SQLSACT 2013/07/15 | Source: SQLServerCentral.com | Category: parameter sniffing
Rating: |  Discuss |   Briefcase | 6,754 reads

Using DAX to retrieve tabular data

Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window of SSMS to directly access data from a tabular SSAS database, an in-memory database that uses the xVelocity analytics engine and compression. Robert Sheldon shows how easy it is to retrieve data from a tabular database.  Read more...
By Additional Articles 2013/07/15 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,708 reads

Security for SQL Server User Defined Data Types

I have a group of developers that I support and they are reporting they cannot see columns within their tables. I have granted them db_datareader permissions which is a standard at my company for QA environments. Why can't they see their column definitions? Check out this tip to learn more.  Read more...
By Additional Articles 2013/07/12 | Source: MSSQLTips.com | Category: data types
Rating: (not yet rated)  Rate this |   Briefcase | 3,277 reads

Sending E-Mail from SQL 2008 Express

This article provides a comprehensive solution to sending email from SQL Express 2008 and Express 2008 R2.  Read more...
By Andrew Prisk 2013/07/12 (first published: 2010/11/04) | Source: SQLServerCentral.com | Category: sql server express
Rating: |  Discuss |   Briefcase | 15,505 reads

Dynamically Truncate a Partitioned Table

Wouldn't be great if you could truncate any partition of a partitioned table with one T-SQL statement? This article shows you how.  Read more...
By Steven Rao 2013/07/11 | Source: SQLServerCentral.com | Category: partition switch
Rating: |  Discuss |   Briefcase | 3,738 reads

SQL Server: How Important Are Index Statistics

In this article Greg Larsen will show you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics.  Read more...
By Additional Articles 2013/07/11 | Source: Database Journal | Category: indexes
Rating: (not yet rated)  Rate this |   Briefcase | 2,836 reads

How to Post Performance Problems

How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw.  Read more...
By Gail Shaw 2014/01/17 (first published: 2009/06/12) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 45,573 reads

An Automated Process to Archive Big Tables

Many databases have large tables with hundreds of millions of rows. However, many of these tables are simply keeping a log or history data that can be archived and kept outside the user database in a special archive database.   Read more...
By Leo Peysakhovich 2013/07/10 | Source: SQLServerCentral.com | Category: archiving
Rating: |  Discuss |   Briefcase | 6,666 reads

Understanding SQL Server Query Optimization Statistics

In this article, you will learn what query optimisation statistics are and how SQL Server query optimizer uses statistics. You will also learn how to create and manage statistics, and what are the different ways to determine when statistics were last updated in SQL Server.  Read more...
By Additional Articles 2013/07/10 | Source: SQL Server Performance | Category: query optimizer
Rating: (not yet rated)  Rate this |   Briefcase | 4,038 reads