How to secure SQL Server?
Databases are an important reservoir of sensitive information, and that is why it is important for us as a DBA...
2012-10-15
852 reads
Using SQL Server 2012 FileTables
Reblogged from Basit's SQL Server Tips:
SQL Server 2012 allows you to store file/directories in a special table called FileTable that...
2012-10-15
1,038 reads
(Mis)Using DBCC Page
In one of my presentations recently I was recommending DBCC CHECKDB on every database every day. I realize that isn’t...
2012-10-15
1,488 reads
A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the...
2012-10-15
1,857 reads
Why Tune Queries?
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
3,003 reads
Last Weeks Top 10 “Reading” Links #2
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-15
718 reads
SQL Server # TSQL to Convert STRING in PROPER format
Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...
2012-10-18 (first published: 2012-10-15)
13,518 reads
Introduction to SQL Server at Christmas
There are still some seats left on the SQL Server 2008 A Comprehensive Hands-On Introduction that I will be presenting...
2012-10-15
728 reads
Office 2013 BI and Mobility
I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about...
2012-10-15
856 reads
IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM
Dear Friends
Firstly, I want to say thanks for your support & liking my blogs that make it possible.
I like to share...
2012-10-15
588 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers