Microsoft GeoFlow new Excel 2013 add-in
Hi
Microsoft released new add-in (Preview) for Excel 2013 and we decided to do a video so here it is...
2013-04-15
752 reads
PowerShell – Find Disk Drive Details of local or remote Server
Name of the Function : Get-DiskDriveDetails
Input Parameter : ServerName
Ouptut : Grid view, you can sort and force condition on specific output column
Function call...
2013-04-15
997 reads
PowerShell – Find top 10 Largest files of a local or remote Drive
Name of the function: Get-LargestFile
The Input parameters are ServerName and Drive.
Function call
PS:\>Get-LargestFile HQDB001 E
In this case HQDB001[ServerName] and E[Drive]
****************************
Code:-
***********************
Function Get-LargestFile([String]$server,[char]$drive)
{
Get-ChildItem \\$server\$drive$...
2013-04-15
1,903 reads
Last Weeks Top “Reading” Links #28
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-15
490 reads
Event Notifications 101 – Intro to Event Notifications
Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server. And...
2013-04-15
658 reads
Finding SQL Server Installs with Powershell, Again
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
955 reads
SQL Server – Import Data from Excel using T-SQL
To import data from an Excel file to SQL Server you can use SQL Server Import and Export Wizard. You...
2013-04-15
29,033 reads
DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants
sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...
2013-04-15
1,070 reads
Determining when statistics were last updated in SQL Server?
I received an email from friend today asking how he can see when statistics were last updated in SQL Server....
2013-04-15
3,528 reads
PASS SQL Saturday in Chicago Presentation Slides
Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL...
2013-04-15
766 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers