AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-10 (first published: 2012-02-08)
10,082 reads
SQLDownSouth
AlwaysOn: Configuring Secondary Read-Only Access
Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...
2012-02-08
1,078 reads
Speaking for Baton Rouge UGs and SQL Lunch Next Week
I have been quiet over the past year trying to get acclimated to my new job and my new found work...
2012-02-03 (first published: 2012-02-02)
1,399 reads
Speaking for Baton Rouge UGs and SQL Lunch Next Week
I have been quiet over the past year trying to get acclimated to my new job and my new found...
2012-02-02
386 reads
PowerView: Coordinating Chart Colors
During a recent customer engagement I was asked if it was possible to ensure that the colors in a Line...
2012-01-10
1,599 reads
Speaking at Knoxville SQL Server User Group
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
987 reads
Free Business Intelligence Workshop
If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop. The details are...
2011-11-01
1,666 reads
SSIS 2012: Project Reference
One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using...
2011-10-24
3,240 reads
SQL Server 2012 SSIS – Why is my toolbox empty?
So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed...
2011-10-13
32,463 reads
SSRS 2008 R2: Implementing Row-level Security
When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there...
2011-10-13
9,783 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers