|
|
-
|
|
Both mean that an user could generate their own reports and they are shielded from underlying data infrastructure. This empowers end-users as they do not need to always ask IT for help..
A one-line statement about [powerview][1]: Delight users with an ...
|
|
-
|
|
Go to MSDN profile > Edit my profile > Input URL's of your social network profiles
I just did, [My profile][1]
[1]: http://social.msdn.microsoft.com/Profile/Paras%20Doshi...
|
|
-
|
|
If you ever add a default constraint on a table without giving it a name, SQL Server will give it a somewhat random name which you cannot guess.
To drop those constraints such a query might come in handy:
DECLARE @query NVARCHAR(MAX)
SET @query...
|
|
-
|
|
It is simple rule, but maybe some people will find this post useful.
From MSDN: "When a virtual method is called, the actual type that executes the method is not selected until run time. When a constructor
calls a virtual method, it is possible that t...
|
|
-
|
|
I was looking into some table creation scripts in source control today. I found that the developers used two ways to check if the table exists in the database.
Few scripts employed `information_schema.tables` vs `sys.objects`. I personally, have been ...
|
|
-
25
Liked
| 27
Learned
| 3
Comments
|
|
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), '"-...
|
|
-
|
|
While installing a windows service I wrote this command in my installation script (not using the installutil.exe) and used a service user account.
SC.EXE create MyService
binPath= "%CD%\MyService.exe"
start= auto
obj= "domain\Myserviceuser" ...
|
|
-
|
|
sql bi - product name change alert: vertipaq is now refferred to as xVelocity...
|
|
-
|
|
It's quite old, but new for me. Great method to parse string is using of recursive CTE, as showed in Table Function:
CREATE FUNCTION fn_SplitString(@str NVARCHAR(MAX), @sep NVARCHAR(MAX))
RETURNS TABLE
AS
RETURN
(
WITH sepPos ...
|
|
-
|
|
If you do not need them: Go to pivot-table options > Totals and filters > **uncheck** Show Grand Totals for rows/columns...
|
|