Creating Custom Reports for SSMS
The new custom report feature of SQL Server 2005 SP2 allows you to incorporate Reporting Services report definitions (.rdl) files into SQL Server Management Studio (SSMS).
2007-11-06
2,996 reads
Articles
Replicate Stored Procedure Execution
Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.
2007-11-05
7,687 reads
2007-11-05
48 reads
Importing Text-based data: Workbench
Robyn and Phil return with some fresh ideas about how to import text files into SQL Server, without resorting to DTS or SSIS scripting. They go on to show how much can be done in TSQL
2007-11-05
2,788 reads
SQL Saturday 2007 - Free Orlando SQL Server Event in November
The Orlando PASS Chapter is hosting a free SQL Server event on November 10th, 2007. They have 30 technical sessions scheduled and more than 270 people have registered to attend! I know a few of the people organizing this and it should be a GREAT event!
2007-11-05 (first published: 2007-07-30)
4,187 reads
String Functions: The .Properties Function, Part II
Business Intelligence Architect Bill Pearson continues his hands-on introduction to the .Properties function. In this article, we examine the use of the TYPED flag within the .Properties function to deliver a strongly typed value using .Properties.
2007-11-05
1,942 reads
Linking Access to SQL Server
For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.
2007-11-02 (first published: 2006-01-25)
27,138 reads
A Brief History of Programming, Part 1
In part 1 of his series on the history of programming, David Chisnall takes a look at some of the developments of the last few decades that have created the current crop of languages and discusses where they came from.
2007-11-02
4,942 reads
Using the kill to cure
Code profiling tools can help cure most performance problems, but sometimes the problem is so severe that you'll first need to know how to wield computing's least understood tool, the debugger, before diving in with the Profiler. Brian Donahue, Crash Scene Investigator, is on hand to explain why.
2007-11-02
2,944 reads
Getting the Most Out of SQL Server 2000's Query Analyzer, Part III
In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.
2007-11-01 (first published: 2002-08-01)
38,992 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Forums
BCA KCP Urip Sumoharjo TLP/,WA 08216977749
Jl. Jend. Urip Sumoharjo No.133, Kepatihan Wetan, Kec. Jebres, Kota Surakarta, Jawa Tengah 57129
BCA KCP Tebet Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, Tebet...
BCA KCP Purwosari TLP/WA 08216977749
Solo Center Point, Ruko No. A11 & A12, Sondakan, Kec. Laweyan, Kota Surakarta, Jawa...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers