Presentation Design – Before and After
Recently I gave a session on the SQL Server Days about the new features for business intelligence in SQL Server...
2015-10-15
471 reads
Blog Posts
SQL server Encryption – Transact SQL Functions.
In the previous blogs we came across various encrypt functions like ENCRYPTBYKEY(),ENCRYPTBYASYMKEY(),ENCRYPTBYCERT().We also saw the corresponding decrypt functions likeDECRYPTBYKEY(),DECRYPTBYCERT(),DECRYPTBYASYMKEY(),DECRYPTBYCERT(),We shall...
2015-10-15
1,516 reads
SQL Source Control and Git–Getting Started
It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS...
2015-10-15 (first published: 2015-10-05)
7,610 reads
Best Tools for Taking Notes In Development
Best Tools for Taking Notes In Development
Developers have a lot to juggle. Do a few of these things sound familiar:
Juggle...
2015-10-14
646 reads
Best Tools for Taking Notes In Development
------------ UPDATE: 2016-04-08 10:12 ------------
Been working through some issues with Clarify app on my personal computer, something I messed up. @trevordevore...
2015-10-14
276 reads
Congratulations New 2015-2016 BRSSUG Officers!
We elected new officers tonight for the Baton Rouge SQL Server User Group Official PASS Chapter, the second year in...
2015-10-14
486 reads
Drill Down with Power BI Visualizations
A couple weeks ago in a recent update to Power BI, an enhancement was added to enable a drill-down action...
2015-10-14
2,020 reads
Drill Down with Power BI Visualizations
A couple weeks ago in a recent update to Power BI, an enhancement was added to enable a drill-down action...
2015-10-14
418 reads
Dynamically Read event_file Data
In the previous article I covered the basics on extracting the payload for the events in a session from the event_file...
2015-10-14
850 reads
Dynamically Read event_file Data
There needs to be a more efficient means of grabbing the file without having to know the location. Knowing the session name should be adequate enough to parse the...
2015-10-14
10 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers