PowerShell provides comment-based help for functions and scripts with Get-Help, but when you want to document modues or generate a complete indexed API in HTML format, just as you can with Sandcastle for .NET or javadoc for Java, then stronger magic is required. Michael Sorens shows you how it is done, with source code.
2013-07-18
3,632 reads
Join Red Gate for a free a seminar on July 26 (the day before SQL Saturday Sacramento). SQL Server MVP experts, Steve Jones and Grant Fritchey will present sessions featuring best practices for SQL Server database development and deployment, in addition to showing Red Gate tools in action.
2013-07-18
1,834 reads
SQL Saturday will be in Iowa City on July 27, 2013. This free day of SQL Server Training and Networking will also have pay-for pre-conference sessions presented by Bill Pearson, Louis Davidson and Tim Mitchell.
2013-07-18
2,185 reads
SQL Saturday is coming to Sacramento on July 27, 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday also features a paid-for full day pre-con session with Kalen Delaney
2013-07-17
422 reads
This article looks at SQL Server locking and transaction isolation levels, how to set the transaction isolation level, and how some isolation levels use locking, while others use row versioning. It also explains what type of locks data update requires.
2013-07-17
3,573 reads
Learn about orphaned distribution transactions in SQL Server and how you can clear them.
2013-07-16
6,531 reads
Some companies put business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual in companies that use the SQL Server layer to perform business tasks, such as finance operations, or incorporate application functionality into the programmability layer. Here's a tip to preserve secrecy on some procedures, views or functions in order to maintain security.
2013-07-16
3,864 reads
Join us for a free day of SQL Server training and networking on July 27 in Cocoa Beach, Florida.
2013-07-16
2,065 reads
This article aims to demonstrate bad parameter sniffing and its effects on memory grants.
2013-07-15
7,204 reads
Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window of SSMS to directly access data from a tabular SSAS database, an in-memory database that uses the xVelocity analytics engine and compression. Robert Sheldon shows how easy it is to retrieve data from a tabular database.
2013-07-15
3,237 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Ruko Srondol Square, Jl. Setia Budi No.147 Blok 5 & 6, Srondol Kulon, Kec....
Komplek Ruko Cikarang Square, Jl. Raya Cikarang - Cibarusah No.B12, Pasirsari, Cikarang Sel., Kabupaten...
Jl. Margonda No.88 A-C, Kemiri Muka, Kecamatan Beji, Kota Depok, Jawa Barat 16423
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers