(Seth Delconte) Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always proved to be tricky for the relational model. They can be used very effectively where the attributes are sparse for any given entity and very numerous across all e
Tag: sql server
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name
(Pinal Dave) Place: Any Developer Shop Scenario: A developer wants to drop a column from a table
Enhanced Features in Database Restore in SQL Server 2012
(Dinesh Asanka) In a typical production environment, in order to recover data in the even of disaster, most DBAs will schedule a robust backup plan. Since scheduling a full back-up during peak times will have an impact on database performance, most DBAs will have combination of full, differential an
Using Cell-Level Encryption in SQL Server
(Basit A. Farooq) Industry guidance such as the Payment Card Industry Data Security Standard (PCI-DSS), Healthcare Insurance Portability and Accountability Act (HIPAA) and numerous state privacy breach notification laws require the use of encryption for sensitive data such as credit card numbers, se
Using SqlDataReader’s new async methods in .Net 4.5 Beta, Part 2: Examples
(Daniel Paoliello) In the previous post about the new column-level asynchronous methods added to SqlDataReader (and DbDataReader) we covered two new SqlDataReader methods (IsDBNullAsync and GetFieldValueAsync), how data is read from the network by the data reader and guidance on how to when to us
New SQL Server Function to Format Dates
(Daniel Calbimonte) SQL Server 2008 and earlier versions used the CONVERT functions to handle date formatting. In this tip, Date and Time Conversions Using SQL Server, we have a list of the available examples on how to use the CONVERT function to handle different date formats.
SQL SERVER – Example of Width Sensitive and Width Insensitive Collation
(Pinal Dave) I had a great time writing blog post SQL SERVER – Effect of Case Sensitive Collation on Resultset. It was interesting to see lots of questions related to collation based on this blog post. However, one of the question, I find very interesting and though to share today here.
SQL Server Login Failure Error 18456, Severity 14, State 10
(Jugal Shah) Recently I experienced a situation where a SQL Server login failed with this error message: Error: 18456, Severity: 14, State: 10.
Drop all tables in an MS SQL Server database
(Dan Haywood) Currently working on a JDO DataNucleus object store for Apache Isis, as part of an app that’s gonna be deployed onto MS SQL Server.
Contained Databases in SQL Server 2012
(Artemakis Artemiou) One of the many new features shipped with the release of SQL Server 2012 are“Contained Databases”.