Native C# in Stored Procedures
A new enhancement in SQL Server 2014 allows you to directly enter C# code in your stored procedures.
2014-04-01
4,441 reads
Articles
SQL Server 2014 Has Been Released
Today is the first day of general availability for SQL Server 2014.
2014-04-01
11,666 reads
SQL Server 2014 New Defaults
SQL Server 2014 is being released and a change in the defaults will ensure that more instances will run smoother.
2014-04-01
2,616 reads
Database Master Key Error After Database Restore
When restoring a database to another server, you may get a master key error if using symmetric keys
2014-03-31
43,773 reads
David McCandless Keynoting at PASS Business Analytics Conference 2014
Bringing together business analysts, data scientists, and business intelligence and IT pros, the PASS BA Conference will feature 65+ best-practices, how-to, and strategy sessions by top BA/BI experts. Keynoting this year is Information Is Beautiful author David McCandless.
2014-03-31
346 reads
Applying The Scientific Method to SQL Server Performance Tuning
A relational database is a complex machine that is asked to deal with intricate problems. When things go wrong, it usually takes knowledge, deduction and a systematic approach to track down the root core of problems and to determine the best fix, Joshua Feierman illustrates how this can be done.
2014-03-31
6,661 reads
Solid State Tapes–Prelaunch News!
In the world of data it’s always been about speed. SSD’s have become very common on consumer machines and not unusual in corporate datacenters.
2014-03-31
3,135 reads
The SQL Server 2008 Datetimeoffset Data Type
The Datetimeoffset Data Type was introduced in SQL Server 2008 (and .Net Frameword 3.5) and is the most advanced date and time date type available.
2014-03-28 (first published: 2011-04-18)
17,024 reads
Transactional Replication and the Ballooning Log File
A drive on a mission-critical server is reaching capacity, and the new DBA is panicking. How do you approach a ballooning log file that won’t stop growing?
2014-03-27
8,236 reads
SQL Server Analysis Services ProcessAdd for a Partition
Is there a way to process only the new data for a partition in SQL Server Analysis Services? Yes, this is accomplished in SQL Server Analysis Services with the ProcessAdd option for partitions. Daniel Calbimonte demonstrates how it works.
2014-03-27
4,415 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers