Tags » SQLSERVER

JDBC driver could not establish a secure connection to SQL Server? Say what??!

So I had an interesting problem during a VMware vCenter server setup last week.

The Servers team asked if I could provide some them SQL Server support for their upgraded architecture. 473 more words

Parse Sql Extended event for Login Audits

SELECT
CONVERT(VARCHAR(19),DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), CURRENT_TIMESTAMP),
xevents.event_data.value(‘(event/@timestamp)[1]’,’datetime2′)),120) AS ,
–xevents.event_data.value(‘(event/action[@name=”session_id”]/value)[1]’, ‘int’) AS ,
DB_NAME(xevents.event_data.value(‘(event/action[@name=”database_id”]/value)[1]’, ‘int’)) AS ,
–xevents.event_data.value(‘(event/action[@name=”server_principal_name”]/value)[1]’, ‘nvarchar(max)’) AS ,
xevents.event_data.value(‘(event/action[@name=”client_app_name”]/value)[1]’, ‘nvarchar(128)’) AS ,
xevents.event_data.value(‘(event/action[@name=”client_hostname”]/value)[1]’, ‘nvarchar(max)’) AS , 124 more words

Databases

#0382 - SQL Server - SSMS - Debugging a T-SQL DML Trigger

I often receive questions related to debugging code using SSMS. Based on these questions, I have written a lot of blog posts in the past, however I was recently asked the question: 322 more words

#SQLServer

SQL Server SSMS 16.3 Release

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS 16.3 release includes initial beta support to allow SSMS to display appropriately on high-resolution monitors. 27 more words

General

#0381 - SQL Server - Table design - Is it better to use NEWID or NEWSEQUENTIALID when defining the key as a UNIQUEIDENTIFIER?

Database schema design involves defining the clustered keys (generally the primary key) on a table, and one of the main decisions to be taken is whether to use a clustered key based on a UNIQUEIDENTIFIER/ROWGUID or an INTEGER? 885 more words

#SQLServer

Are SQL Saturday’s Worth It?

This past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held at Indiana Wesleyan. Most of you who end up on this site are probably familiar with it, but for those that aren’t familiar with SQL Saturday events you can check out their site  830 more words

SQLServerPedia Syndication

SQLServer dba skills for developers

Pretty cool article focussing on the important skill for developer: understanding the tools and technologies of SQL Server:

http://www.c-sharpcorner.com/article/dba-skills-for-developers/