Add-In for searching object in SSMS without touching mouse
I was using various “quick find” SSMS add-ins which give you ability to get your tables, stored procedures, functions and...
2011-11-07
1,011 reads
SQL Treeo
New version of SQL Treeo SSMS productivity add-in was released
Hi,
new, second version of SQL Treeo productivity add-in was released.
For little reminder, here are main features of this add-in:
Create...
2011-11-06
2,419 reads
SQL Server 2011 “Denali”: Four new useful DMV
SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them...
2011-09-14
732 reads
SQL Server DMV Views: Getting slow queries within stored procedure
SQL Server DMV Views might be very helpful. Let’s imagine that you have a couple of nested stored procedures and...
2011-09-08
1,780 reads
SQL Server 2011 “Denali”: Give feedback and win nice gifts
Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for...
2011-09-05
638 reads
Creating Facebook page for blog
Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm...
2011-08-29
834 reads
How to write data from user-defined function
Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL...
2011-08-28
1,225 reads
Great new analytical functions in SQL Server 2011 “Denali”
SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read...
2011-08-14
648 reads
Download free SSMS Add-In to create custom folders for database objects
I’ve just finished promised SSMS add-in which enables creating of custom folders directly in SSMS Object Explorer. Idea for add-in...
2011-08-08
3,138 reads
SQL Server 2011 “Denali”: Get T-SQL query metadata without executing it
SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous...
2011-08-03
1,014 reads
Blogs
Navigating Modern Data Architecture: DW, Lakehouse, and Lakebase Explained
By Daniel Janik
The report outlines the evolution in data management systems, transitioning from traditional siloed structures...
Comparing Top AI Tools for Image and Code Generation
By Daniel Janik
The post explores various AI assistants, highlighting their strengths and weaknesses in areas like...
Communications: Three Questions
By Brian Kelley
The better skilled we are communications, the more likely we will be understood. Whether...
Forums
How to optimize queries using AI (SQL Expert)
Comments posted to this topic are about the item How to optimize queries using...
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Planning for the Right Emergency Response
Comments posted to this topic are about the item Planning for the Right Emergency...
Question of the Day
Capacity Planning for an Existing SQL Server Workload?
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers