SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.
2019-03-07 (first published: 2019-03-04)
4,982 reads
This article shows how to download sqlserverbuilds.blogspot.com to build your own automated sql patch level check.
2020-12-24 (first published: 2017-07-03)
4,429 reads
This is a tutorial to download multiple files from internet using the SSIS Script Task.
2016-12-08
6,385 reads
In this example, we will show how to download a file from internet using SSIS.
2016-12-01
9,546 reads
If you want to display variable number of columns in the report I suggest you use a matrix element.To utilise it for this you need to flatten the result of your query. The query can be changed into something like this: select{ [Utility Dimension].[Value].[Current] } on columns,{ CrossJoin( {[TimeByMinute].[All TimeByMinute].[2005].[May].[1] : [TimeByMinute].[All TimeByMinute].[2005].[May].[6]}, {A_list_of_measures }) } on Rowsfrom ACD_Calls This […]
2005-05-24
Frank, Exactly what I've heard (I've read the Pascal debate), and seen from personal experience talking to people who use mySQL (quote: "we just need to store some data; nothing fancy!") ... I still don't get why these people wouldn't use PostgreSQL instead, which has all of the features we know and love
2005-03-31
2005-01-25
keep getting on Error messages on my package: (running on Windows Server 2000 SP4 & MS-SQL 2000 SP3)Context:Error calling open rowset on the provider... Error Source: Microsoft OLE DB Provider for ODBC Drivers funny... but it works fine from my Workstation (XP pro SP-1)any suggestion guys ?? thx for the attention
2004-11-28
29 reads
Is it possible to get all records from a table with a (not in the table existing) value of zero in the parameter. E.G. USE Northwind SELECT * FROM Catagories WHERE CatagoryID = ? CatagoryID can be any value from 1 till 8. When the parameter value filled in for CatagoryID = 0, I want […]
2004-11-26
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-17
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers