Welcome to Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)
Microsoft SDL (Security Development Lifecycle) team released recently two guidance papers: Quick Security Reference - Cross-Site Scripting Quick Security Reference - SQL Injection The SQL Injection subject is not at all new. As an example 9 years passed Read More...
If you answered no, the new name for what we used to know as project Gemini is Power Pivot You can read more about it at http://www.powerpivot.com/ Yyou can also follow the project on twitter http://twitter.com/powerpivot Read More...
Until recently the SQLSeverDataMining.com was the place to get SQL Server DM. Now we have a Data Mining TechCenter . Enjoy ! Read More...
The Specification for TDS protocol is no longer secret. You can read about it on the MSDN site: [MS-TDS]: Tabular Data Stream Protocol Specification or download the PDF version of the documentation (use Save Target As). There are just 124 pages Read More...
I’ve been asked on first of April if the SQL Hero contest is real or not. Just because the guy that asked me saw a post on a blog that day it doesn't mean that it's a joke. It is as serious as it can be. To clear this out I abused the kindness of David Read More...
I am kidding. No one knows everything about SQL Server. Anyway, Microsoft SQL Server Data Services means if you don't care about marketing - SQL Server in the cloud. Resources: SQL Server Data Services (Microsoft Official Site) SQL Server Data Services Read More...
How just vote here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=327537 Read More...
In a discussion with Remus Rusanu , he reminded me that if you use a SqlString to pass a varchar(max) to a client application, the whole value is copied into the memory (think big - a varchar(max) can have up to 2GB). The alternative is to use streaming Read More...
The answer depends on who you asked the question. If you ask an Analysis Services member team he/she might answer XML DDL, MDX ( Multidimensional Expressions ). DMX (as in Data Minining Extensions and not DMX the rapper ), XMLA ( XML for Analysis ), PMML Read More...
Then you can help Microsoft making SSIS better by answering the questions of the next survey: SQL Server ETL Survey: Win a Zune! [quote] This survey will help SQL Server Integration Services (SSIS) team understand your current Data Extract, Transform Read More...
I liked this tool so much that I considered it's worth to do a screencast about it. So here it is: Windows Media Video archive: Download Format: wmv Duration: 00:03:53 Read More...
If you need to see the physical structure of your database you can use DBCC PAGE as described here: Read Index Structure [quote] CREATE TABLE #DBCCIND( PageFID INT, PagePID INT, IAMFID INT, IAMPID INT, ObjectID INT, IndexID INT, PartitionNumber INT, PartitionID Read More...
A year and a half ago I wrote about the undocumented Dynamic Management View sys.dm_os_ring_buffers in SQL Server Professional . Shortly the ring buffers expose internal server state information about memory, exceptions, or schedulers. Each ring buffer Read More...