Monitoring job history using Reporting Services
Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.
2013-09-05
10,635 reads
Articles
Getting Data between Excel and SQL Server using ODBC
With ODBC, you can summarise, and select just the data you need, in an Excel workbook before importing it into SQL Server. You can join data from different areas or worksheets. You can even get data from the result of a SQL Server SELECT statement into an Excel spreadsheet. Phil Factor shows how, and warns of some of the pitfalls.
2013-09-05
4,816 reads
New Enhanced Column Store Index in SQL Server 2014 – Part 1
Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Unlike regular indexes or heaps, which store data in B-Tree structure (in row-wise fashion), the column store index stores data in columnar fashion and uses compression aggressively to reduce the disk I/O needed to serve the query request. In this article, Arshad Ali talks about the new enhanced columnstore index feature in SQL Server 2014.
2013-09-04
2,487 reads
Opportunity for Business Intelligence developer
Red Gate is looking for a Business Intelligence Developer to work with our internal development team on creating business intelligence solutions. You'll be responsible for designing, building, and testing end-to-end BI solutions using the Microsoft BI stack, so we'll expect you to be passionate about understanding data and generating a universe of analytics for your customers – our Red Gaters.
2013-09-04
3,709 reads
Variable Default Values to a Stored Procedure (SQL Spackle)
A way to assign variable and overrideable defaults to input parameters to an SP or FUNCTION using a configurations table.
2013-09-03
8,368 reads
New SQL Monitor Custom Metric: Large Transaction Log Files
If the transaction log autogrows rapidly, it can suggest that log backups are not being carried out frequently enough, or another resource may be preventing the log from truncating. This metric measures the number of transaction log files that are greater than 10 GB. The associated alert is raised when the number of files exceeds a specified threshold.
2013-09-03
2,422 reads
SQL Server Reporting Services Tips and Tricks to Improve the End User Experience
In this article we'll take a look at the following Tips and Tricks for SSRS: Display Total Number of Pages while Navigating, Display Everything in a Single Page, Display Report Parameter Selection, Display No Rows Error Message, Page Settings for Optimal Printing.
2013-09-03
5,988 reads
Common table expressions and circular references
Finding circular references that are stopping your CTE from working.
2013-09-02 (first published: 2011-01-31)
19,747 reads
SQL Saturday #251 Paris, France
SQL Saturday is coming to Paris on September 14th 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday will include a track on Business Intelligence, SQL Server, and something for beginners.
2013-09-02
1,511 reads
SQLServerCentral Webinar Series #26: Best Practices in Database Deployment Part 2
This Tuesday Grant Fritchey and David Simner will give you a step-by-step guide to how you can automate your database deployment Process using Red Gate Deployment Manager.
2013-09-02
1,775 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor BCA KCU BANGKALAN Telp:0817629933
WhatsApp:0817629933 Jl. Trunojoyo No.15 A, Pejagan, Kec. Bangkalan, Kabupaten Bangkalan, Jawa Timur 69112
Alamat kantor BCA KCU HR MUHAMMAD Telp:0817629933
WhatsApp:0817629933 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
BCA KCU BLOK A CIPETE HUB.Tlpn.0821•3111•185
BCA KCU BLOK A CIPETE HUB.Tlpn.0821•3111•185 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete...
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