|
|
-
|
|
Few days back, i was working to add new table in publication in transaction publication. After adding a article in publication and after reinitialized, i see nonclustered index was not copied at subscriber database. I tried reinitialized one more time a...
|
|
-
|
|
Hi all , On PASS Business Analytics Conference(PBAC) in Chicago, Microsoft disclosed a public preview of GeoFlow for Excel (download Here ). "Today we are announcing the availability of the project codename "GeoFlow" Preview for Exce...
|
|
-
|
|
Changing the SQL Server collation once a SQL Server instance has been installed is a tedious process because it involves recreating the master database. Many believe that the server collation is picked up by default and must be changed by master database recreation only. In this post, I show how to ensure that the installation itself always uses the required collation....
|
|
-
|
|
This post is triggered by a question I recently saw in the BR Forum asking ideas for merging two XML documents. I thought of adding another installment to the XQuery Labs series to explain how this can be done from TSQL when required. The examples giv...
|
|
-
|
|
Forgetting the "sa" login is an issue frequently seen in development & QA environments. Generally the Windows login works, but in some cases the IT team who installed the server may have forgotten to add someone to the sysadmin role. This post provides a proactive recommendation and link to a workaround....
|
|
-
|
|
A few days back, while i was working with Alerts for failed scheduled jobs and missing scheduled jobs, i was needed to exclude running jobs. So we can exactly know which jobs are actually failed excluding running jobs and sane case for missing jobs. I a...
|
|
-
|
|
Spreadsheets are one of the most popular software for data manipulation. They are widely used and welcomed by business users with their superior advantages. At the same time, the disadvantages of spreadsheets cause business users to be red faced....
|
|
-
|
|
Why the spreadsheet is still ruling the BI world?
One of the key factors is its low technical requirement. The spreadsheet does not require a complex installation and deployment procedure or the expertise in SQL/MDX/Java script/.Net, let alone a great many of advisory agents and technical experts to give you command....
|
|
-
|
|
Microsoft installers have generally been a source of inspiration for all product development teams. Here is one installation check that I believe should be common to all product installers - the long path name check....
|
|
-
|
|
As we all know web pages are stateless pages and we need to use session variables in web application to maintain some session over page. Some time we divide our application into multiple layers for example business logic layer,database layer etc. This a...
|
|