Count_Big() function
Learned new function for count while going through the channel 9 video for salva. where for a very big table...
2018-01-22
608 reads
Vinay Thakur
Happy New Year… Late:)
Yeah I know its new year and i am back from quite some time. during these days i was learning...
2018-01-13
315 reads
Azure support MySQL & PostgreSQL
After SQL Server support on Linux Microsoft is not have another great enhancement where now Azure supports MySQL and PostgreSQL...
2017-08-27
495 reads
SQL Server 2005 – Failed Maintenance Job
I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those...
2017-08-27
297 reads
Learning – Webcasts/Video
Learning for this week. http://www.pass.org/24hours/2017/security/Schedule.aspxhttp://sqlblog.com/blogs/damian_widera/archive/2017/04/20/sql-server-2017-all-sessions-from-microsoft-data-amp-are-online-complete-list-of-links.aspx http://sqlblog.com/blogs/davide_mauri/archive/2017/05/01/pass-appdev-recording-building-rest-api-with-sql-server-using-json-functions.aspx http://sqlblog.com/blogs/sergio_govoni/archive/2017/04/15/pass-business-analytics-marathon-march-2017-recordings-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/31/the-recording-for-biml-in-the-enterprise-data-integration-lifecycle-is-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/14/the-recording-for-the-ssis-catalog-compare-version-2-launch-event-is-available.aspx Free Microsoft books: https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/
2017-05-21
363 reads
Azure CosmosDB SQL Server
As you know Microsoft has retrieve the data from Hadoop with by polybase and extended the R language to External...
2017-05-21
431 reads
Vnext – Its SQL Server 2017
Yes thats true, SQL Server New version will be release this year and call it “SQL Server 2017” where sql can...
2017-04-24
461 reads
vNext has AG
Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported. https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/
2017-03-23
312 reads
SQL Agent on vNext – Linux
SQL Server is running on Linux now with SQLPAL- SQL Platform Abstraction Layer(SQLPAL) -it will work as a virtual Windows server on...
2017-03-23
422 reads
SQL Server on Linux
Yes that is true, now SQL Server is on Linux. https://www.microsoft.com/en-in/sql-server/sql-server-vnext-including-Linux Download the public preview https://docs.microsoft.com/en-us/sql/linux/ I am learning it...
2017-02-04
726 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers