SQLPort’s new image
After almost 5 years of existence, SQLPort (Portuguese PASS Chapter in Lisbon) is kicking of 2015 with a renewed image...
2015-01-22
539 reads
SQL- Querying XML attributes from XML Column
Read XML column attributes in to two columns DimType and Dimvalue from the below example also retrieve the data matching...
2015-01-29 (first published: 2015-01-22)
38,612 reads
Looking Out for Others Helps You Lead
I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go...
2015-01-22
805 reads
How to install standalone SQL Server 2012 instance ?
Steps to install standalone SQL Server 2012 instance 1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition...
2015-01-22
22 reads
Excel Apps – Not Quite Ready for Primetime
While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I...
2015-01-22
1,106 reads
Exam Prep 70-463: Data Flow Destination Adapters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-01-27 (first published: 2015-01-22)
8,566 reads
How to install standalone SQL Server 2012 instance ?
Steps to install standalone SQL Server 2012 instance
1) Start the setup > Go to Installation from Left > Click on 1st option...
2015-01-22
1,084 reads
Virtual Reality (VR) Meet My #sqlfamily
Virtual Reality? And SQL Server?
“… and never the twain shall meet” bit.ly/1yhgLHS
Or should they?
The time has come for data professionals...
2015-01-22
1,183 reads
Advanced SSIS Training in Dallas
I’m very excited to offer a new course entitled “Advanced SSIS” in the Dallas area this spring. My friend and...
2015-01-21
725 reads
Statistics Parsing
Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when...
2015-01-28 (first published: 2015-01-21)
6,753 reads
Blogs
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers