#Meme15: On Facebook
This will be my first Meme15 (here’s Jason Strate’s original Meme15 post), and today we’re talking Facebook. The question is:
How...
2012-03-15
819 reads
Blog Posts
Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those cases where you are consulting or you have taken...
2012-03-15
9 reads
Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those...
2012-03-15
857 reads
Cached blocking history with sys.dm_db_index_operational_stats
Transactions generate IO, latching and locking on tables and indexes , while attempting to access data. The sys.dm_db_index_operational_stats DMV returns aggregated data...
2012-03-15
1,359 reads
ColoradoSQL for March 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-03-15
648 reads
Data Warehouse Architecture – Kimball and Inmon methodologies
What is the best methodology to use when creating a data warehouse? Well, first off, let’s discuss some of the reasons why...
2012-03-15 (first published: 2012-03-12)
9,526 reads
Execution Plans – Merge Join
The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There...
2012-03-15
5,905 reads
Importing images to SQL server database using T-Sql
Yesterday evening one of the developer asked me that he need a help in importing images into a table. It...
2012-03-15
11,480 reads
Security and Permissions presentation from the Baton Rouge SQL Server User Group Meeting, 3/14/2012
Last night I presented a new presentation I'm working to add to my inventory, SQL Server Permission and Security. This...
2012-03-15
592 reads
SQL Server 2012 Performance Test: Truncate a Date/Time to Different Parts
SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of...
2012-03-15
2,975 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers