SQL Tact

There's an issue with some characters in T-SQL when validating numeric values out of raw varchar fields, and it can...

2013-12-17 (first published: 2013-12-12)

5,728 reads

Upcoming Special Events for the Baton Rouge SQL Server User Groups

by Will Assaf

SQL Tact

I'm happy to announce a big slate of upcoming events for Baton Rouge User Groups and especially the SQL Server...

2013-12-03

640 reads

Speaker Idol Competition at the Hammond .NET User Group

by Will Assaf

SQL Tact

Here's the link to download the sample scripts and meme-tastic slidedeck from my presentation "SQL Server Indexes in Your Ill-Begotten...

2013-11-20

532 reads

Potential Backup Software Issues with Read-Only Databases in FULL Recovery

by Will Assaf

SQL Tact

If you decide to park a database in read-only mode for a long period of time, go ahead and alter...

2013-11-13 (first published: 2013-11-05)

2,026 reads

SQL Saturday #255 Dallas 2013 - SQL Server Permissions and Security Principals

by Will Assaf

SQL Tact

500+ IT pros at UT-Arlington this weekend for SQL Saturday #255 Dallas!

Notes from today:

A big shout-out to SQLSat Dallas organizer...

2013-11-03

712 reads

PowerShell: Delete Unneeded Rows/Columns In Excel

by Will Assaf

SQL Tact

I had a project to automate the import of a large number of excel files via SSIS into SQL 2012....

2013-11-08 (first published: 2013-11-01)

6,969 reads

SQL Server Configuration Manager (sqlserverManager11.msc) Hidden after Windows 8.1 Upgrade

by Will Assaf

SQL Tact

You may have noticed, like I did, that after upgrading-in-place from Windows 8 Enterprise to Windows 8.1 Enterprise, my local...

2013-10-22

7,263 reads

"SQL Server: Bolts to Buzzwords" presentation for the Hammond .NET User Group at Southeastern Louisiana University

by Will Assaf

SQL Tact

One of my favorite groups to speak for (aside from the Baton Rouge SQL Server User Group) is the Hammond...

2013-10-17

432 reads

Houston Tech Fest 2013 - SQL Admin Best Practices with DMV's

by Will Assaf

SQL Tact

Here is the downloadable file with all my sample scripts and slidedeck from my SQL Admin Best Practices with DMV's presentation from...

2013-09-28

1,044 reads

Replicated Stored Procedure Execution

by Will Assaf

SQL Tact

One feature that many of my clients are unaware of is that the batched execution of a stored procedure can be...

2013-09-04

2,113 reads

SQL Tact

It's Dangerous to ISNUMERIC, Take This Try_Convert

Upcoming Special Events for the Baton Rouge SQL Server User Groups

Speaker Idol Competition at the Hammond .NET User Group

Potential Backup Software Issues with Read-Only Databases in FULL Recovery

SQL Saturday #255 Dallas 2013 - SQL Server Permissions and Security Principals

PowerShell: Delete Unneeded Rows/Columns In Excel

SQL Server Configuration Manager (sqlserverManager11.msc) Hidden after Windows 8.1 Upgrade

"SQL Server: Bolts to Buzzwords" presentation for the Hammond .NET User Group at Southeastern Louisiana University

Houston Tech Fest 2013 - SQL Admin Best Practices with DMV's

Replicated Stored Procedure Execution

Blogs

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

AgentDBA vs Critical SQL Server

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

Forums

Alamat kontak resmi BCA KCP Tebet Telp:0818751777

Stan Phone Number Australia +61-1800868603 Quick Help Guide

BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887

Question of the Day

Detecting Characters