SQL Server 2012 Express installation failed issue
I got an strange error when installing SQL Server 2012 Express
Environment:Window Server 2008 R2 Enterprise + SP1Microsoft Visual Studio 2012 installed.Net...
2013-08-07
1,907 reads
Blog Posts
SQL Training – Introduction to SQL Server Data Tools
Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...
2013-08-07
6,058 reads
SQL Training – Introduction to SQL Server Data Tools
Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...
2013-08-07
851 reads
SQLSaturday Numbers For Period Ending June 30, 2013
Just saw this in the PASS Connector:
The SQLSaturday numbers are in for our fiscal year, which ended June 30, with...
2013-08-07
653 reads
SSRS – Download all RDL files from Report Server in one go.
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-07
1,244 reads
SSRS: Report Actions, URL Actions and SharePoint
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
20 reads
SSRS: Report Actions, URL Actions and SharePoint
I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report. The child / sub-report originally had two mandatory parameters and the...
2013-08-07
42 reads
Deadlock – A quick, easy view
Deadlocks are rough to work with. Here are the scripts I use to capture deadlocks, find which ones are reoccurring,...
2013-08-06
2,089 reads
Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-08-06
940 reads
DMV-12 : Retaion in Session & Transaction……..sys.dm_tran_session_transactions
sys.dm_tran_session_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188739.aspx
Returns correlation information for associated transactions and sessions.
This DMV helps...
2013-08-06
1,169 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers